Posts Open a mdb on x64 machine w/ x86 office installed
Post
Cancel

Open a mdb on x64 machine w/ x86 office installed

source http://blog.codefluententities.com/2011/01/20/microsoft-access-database-engine-2010-redistributable/

1-download the DatabaseEngine x64 version https://www.microsoft.com/en-us/download/details.aspx?id=13255 while trying to install, you get a message that tells -> you have to uninstall office! thats great microsoft! 2-use the following DOS command :

1
AccessDatabaseEngine_X64.exe /passive

on your program, the connection string, should be : jsProvider=Microsoft.ACE.OLEDB.12.0;Data Source=test.mdb

Solution 2 - Add ODBC (file DSN) to MDB (x64)

This problem can occur because of a architecture problem (32-bit office running on 64-bit windows).

The following steps can be used to solve this problem:

  1. Navigate to “C:\Windows\SysWOW64”
  2. Find “odbcad32.exe”, right click on it and do “Run As Administrator”
  3. Then continue following the steps listed in the Database Toolbox Guide.

After following the above steps, you will be able to see all the data sources.

origin - http://www.pipiscrew.com/?p=4706 add-odbc-file-dsn-to-mdb-x64

This post is licensed under CC BY 4.0 by the author.
Contents

Trending Tags