By using this site you agree to the use of cookies for analytics and personalized content.
I agree Learn More
The technical articles cover a range of survey topics related to various features of Stimulsoft Reports. Interesting and useful tips, hints, how-tos, code snippets etc.

Connecting to Microsoft Access Database under x64 operation systems?

Share this post

Submit to FacebookSubmit to FacebookSubmit to TwitterSubmit to TwitterSubmit to GoogleSubmit to GoogleSubmit to LinkedInSubmit to LinkedInSubmit to VKSubmit to VK
Let's discuss a very important thing – creating an OLEDB connection under a 64-bit OS with use of the adapter Microsoft Jet 4.0. This adapter is not supported in 64-bit applications. But the issue can be solved in several ways and takes this a couple of minutes. Despite the fact that the database adapter Microsoft Jet is present in Windows 7, it is a bit outdated. Therefore, you should use the new adapter Microsoft.ACE.OLEDB.12.0. This adapter can be downloaded from the official source, completely free of charge.

Once you have downloaded it. Install it. Run the file, accept the license agreement, define the installation location and wait for a while. It takes a couple of minutes. After the installation is finished, it is better to restart the report designer (if opened), and in case the installation wizard offers to restart the system, just follow its request. Next, create an OLEDB connection to the data source.

It should be noted that this adapter is designed exclusively for 64-bit applications; it will not work with 32-bit versions of Microsoft Office. Therefore, Microsoft.ACE.OLEDB.12.0 should be used only with 64-bit versions of the Office.

Here is a video that shows how to install the adapter Microsoft.ACE.OLEDB.12.0 and create the OLEDB connection to the data source.

Also, this problem can be solved without the adapter Microsoft.ACE.OLEDB.12.0. You can change the properties of your project. Go to the properties of the project by selecting the appropriate item from the context menu, or by Project -> Properties..., in the tab Build change the Platform target, selecting the value x86. After this, run the project, call the designer and create the OLEDB connection to the data source. This method can be watched the video below.
TwitterFacebookRSSLinked inYoutubeStimulsoft BlogViberWhatsAppSkypeTelegram