Today's Win7 systems are typically installed in 32-bit office, because Microsoft recommends 32-bit office, which is more compatible and more stable. When using Access as a database, C # operations access, if Access is accdb, then everything goes well, Win7 system has the appropriate components to access ACCDB, you can use C # calls. If it was an MDB, it was previously accessed using Jet on XP, and jet was deprecated on Win7 because the Win7 system itself did not have the components of jet. And there's a replacement. Microsoft Access Engine accesses the Access database by Ace, and as long as this is installed, everything is OK.
However, there will be problems when installing. When you download from the Microsoft homepage, you will find two versions, one for the 32-bit system and the other for the 64-bit system. Because we are a Win7 64-bit system, and the DLL used for the project is 64-bit, you install Microsoft Access engine-x64, but the installation will detect that the 32-bit Office installed on your machine requires you to upgrade office to 64-bit, Does it really take a lot of trouble to unload and reload office? There is still a solution.
- Use the "/passive" command to install, such as "C:\directory Path\accessdatabaseengine_x64.exe"/passive
- After the installation is complete, view the registry hkey_local_machine\software\microsoft\office\14.0\common\filespaths, delete the Mso.dll
The problem is resolved, and you can use C # Aces to access the Access database. Note that the second step is not minimal, or the Office config configuration issue will occur, and Office will reinstall Office if it is started.
Transferred from: http://blog.csdn.net/sundacheng1989/article/details/17925431
With Access engine Microsoft official:
http://www.microsoft.com/zh-cn/download/details.aspx?id=13255
To install Microsoft Access Solution in a 64-bit Win7 operating system