Access 2007 & x64 Connections

Crones — Mon, 19 May 2008 16:52:40 GMT

Just an FYI...

Developing on Vista x64 and trying to establish a connection to an Access 2007 database generated this error:
The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.

Access 2007 Connection String:
Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\myFolder\myAccess2007file.accdb;Persist Security Info=False;
Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\myFolder\myAccess2007file.accdb;Jet OLEDB:database Password=MyDbPassword;

The Access 2007 Database Engine currently only has 32-bit support.

For a .NET assembly built for "Any CPU" (the default platform setting in
build configuration), when it's run on x64 system, the JIT compiler will
compile it as 64-bit process; and we cannot load the 32-bit provider
(driver) in a 64-bit process.

The workaround is that you have to compile your assembly as a 32-bit
process specificially:

1) in VS2005, menu "Build/Configuration Manager"
2) in the "Configuration Manager" dialog, select ""
3) in the "New Solution Platform" dialog, select "x86", press OK

Also, there does not appear any plans to create a x64bit version.

RE: Access 2007 & x64 Connections

Guillermo Vilas — Mon, 19 May 2008 16:52:40 GMT

The steps for solving the issue applies to Windows XP Professional X64 too. ;)

RE: Access 2007 & x64 Connections

StrataFrame Team — Mon, 24 Mar 2008 08:38:18 GMT

That's very good to know about the 32-bit version of the Access connector. Thanks.

We ran into the same issues with the VFPOLEDB driver as well. However, since it runs several pieces through separate processes, we haven't been able to use VFPOLEDB at all on a 64-bit machine.

StrataFrame Forum » StrataFrame Application Framework - V1 » Business Objects and Data Access (How do I?) » Access 2007 & x64 Connections

Access 2007 & x64 Connections

RE: Access 2007 & x64 Connections

RE: Access 2007 & x64 Connections