Read Access Database from within 64-bit app

[Brent Burgess]

Hi All,

I am creating a drawing manager, to be run inside 64-bit AutoCAD. From what I have read, there is no 64-bit version of the msjet40.

A solution that I thought was going to be successful was to build the class as a 32-bit, but I still get the error.

What I am trying to find out, is there a way that I can read an access database from withing a 64-bit app?

Thanks

Brent

[jmcilhinney]

You can't build a 32-bit class. Assemblies, i.e. .NET DLLs and EXEs are either 32-bit or 64-bit. If an assembly is 32-bit then it can only load other 32-bit assemblies. If an assembly is 64-bit then it can only load other 64-bit assemblies. As far as I'm aware, your only options would be:

1. Create a separate 32-bit application and then provide a communication channel between the 64-bit app and the 32-bit app.

2. Use ACE instead of Jet and install the 64-bit version of ACE 2010. You would have to either install the 64-bit version of Access 2010 or just the 64-bit version of ACE 2010, which would preclude you from installing the 32-bit version of Office 2007 or Office 2010.

3. Don't use Access. Use a different database that does support 64-bit apps. One option would be SQL Server CE, which can be deployed with or without installation.