About Win7 64-bit systems access to access through ODBC experience

Recently, while working relatively idle, the computer's operating system has been re-installed, from the original XP replaced by WIN7 (64-bit), the results encountered a series of application data access problems.

Question 1: Many of the small programs that I wrote with VS2010 are running in Win7, and the error is verified and the Access database is accessed.

Question 2: knime, the analysis tool that you use frequently, has an error when reading an Access database (Knime is 64-bit).

In order to solve the above problems, the Internet search for some, initially to find out the cause of the problem.

Because I installed the Office2007 is 32-bit (general users do not recommend the installation of 64-bit Office, specifically refer to this article: 32-bit and 64-bit version of Office similarities and differences), so office comes with the access driver 32-bit, My application is compiled by default as an any CPU, so the 64-bit system accesses the 64-bit ODBC driver by default, and the driver is not found.

Solution 1: Recompile the program, the target platform to choose X86, this method can solve the problem 1, the operation is very simple.

There is a problem: The source code of the program needs to be able to recompile itself, so there is nothing for problem 2.

To solve problem 2, I went on to search for a workaround and found a new solution that was to install the 64-bit ODBC driver on the Win7. Main reference This article: 64-bit system to install ODBC driver method

The easiest way to install a 64-bit ODBC driver on Win7 is to install 64-bit Office, but we already have 32-bit Office installed before, can we install the ODBC driver without installing the 64-bit office directly?

The way to do that is to install Microsoft Access Engine, which is downloaded from the Microsoft website called Accessdatabaseengine_x64.exe.

But the new problem comes again, when you install Accessdatabaseengine_x64.exe, the program also detects that you have installed 32-bit office and cannot continue with the installation.

This time you need to install the package of the program to move small surgery, first go to Microsoft to download a Microsoft Windows SDK for Windows 7 and. NET Framework 3.5 SP1, download the program called Winsdk_web.exe.

Install Winsdk_web.exe, and then from the installation directory to find Orca.msi, the specific location forgotten, you can search under. Our real goal is to have this orca, an MSI file editor. Run the Orca.msi installation.

Next processing installation program, first with WinRAR Accessdatabaseengine_x64.exe decompression, not directly right-click Decompression, first run WinRAR, and then Accessdatabaseengine_ X64.exe Drag the past, you can decompress, after the decompression has two files, one of which is an MSI file, called Aceredist.msi, then run Orca program, the Aceredist.msi Open, in the left tables found launchcondition items, and then on the right con Dition found Blockinstallation, delete the article, and then save.

Then run Aceredist.msi again, this time will not be prompted to install the 32-bit Office, the smooth installation of the end, 64-bit ODBC driver.

This time to run Knime is no problem, the operation of Method 2 is more troublesome, but the use of the tools are Microsoft source, and a good deal, the next time you can directly reuse.

I've got the aceredist. The MSI is placed on the net disk:

Http://pan.baidu.com/s/1eS6zMro

About Win7 64-bit systems access to access through ODBC experience