How To Fix Microsoft Access Error 3847

Published by Jacob Martin on March 7, 2015

Error Number :         Error 3847

Error Name:              ODBCDirect is no longer supported

Error Description:    ODBCDirect is no longer supported. Rewrite the code to use ADO instead of DAO.

Symptoms of Error 3847

• “Error 3847″ appears and crashes the active program window.
• Windows runs sluggishly and responds slowly to mouse or keyboard input.
• Your computer periodically “freezes” for a few seconds at a time.
• Your PC sometimes crashes with Error 3847 when running the same program.
• “ODBCDirect is no longer supported” is displayed.

These 3847 error messages can takes place during program installation, while a Microsoft Corporation-related software program (eg. Microsoft Access) is running, during the installation of the Windows operating system or even during Windows startup or shutdown. Keeping record of when and where your 3847 error occurs is a dangerous piece of information in troubleshooting the problem.

Causes of Error 3847

• Corrupt download or incomplete installation of Microsoft Access software.
• Virus or malware infection that has corrupted Windows system files or Microsoft Access-related program files.
• Another program maliciously or mistakenly deleted Microsoft Access-related files.
• Corruption in Windows registry from a recent Microsoft Access-related software change (install or uninstall).

Runtime Errors such as “Error 3847” can be caused by a variety of factors, so it is very important that you troubleshoot each of the possible causes to prevent it from recurring.

Below mentioned is a list of troubleshooting steps to resolve your Error 3847 problems. These troubleshooting steps get progressively more difficult and it consumes time too, so we strictly recommend attempting them in ascending order to avoid unnecessary time and effort.

Step 1: Repair Registry Entries Associated with Error 3847

Step 2: Conduct a Full Malware Scan of Your PC

Step 3: Clean Out Your System Junk (Temporary Files and Folders) With Disk Cleanup (cleanmgr)

Step 4: Update Your PC Device Drivers

Step 5: Utilize Windows System Restore to “Undo” Recent System Changes

Step 6: Uninstall and Reinstall the Microsoft Access Program Associated with Error 3847

Step 7: Run Windows System File Checker (“sfc /scannow”)

Step 8: Install All Available Windows Updates

Step 9: Perform a Clean Installation of Windows

After applying the above mentioned steps if you are still unable to fix Error 3847 in ms access then you can also use software like MS Access Repair Tool in order to fix such errors. This software allows you to recover any kind of corrupted data.  It can repair any corrupted, damaged or inaccessible MS Access MDB and ACCDB files and errors occurs in MS Access database. It has a user-friendly interface.

steps to repair the error:

Step 1:Download and install Stellar Phoenix Access recovery software.

Step 2: Just click on “Open MS access file” button on the toolbar. You will find a pop-up window from where you can search or select for an ‘.mdb’/’.accdb’ file in your PC.

Step 3: Look at the image below you will find same image in your computer screen. With the help of this “Customers” table you will be able to view both the data and column information.

Step 4:Preview the column information of “Employees” table.

Step 5: Now you will the preview of database query.