Topic: Visual lisp and MS access 2010 64 bit

[masoud_123]

I think it's an old unresolved problem!

Anyone knows how to access to MS Access database (mdb) using Visual Lisp on 64 bit OS?

I've read all related topics here and other forums but I've just been getting confused.

Anybody knows something or having piece of code? PLEASE share!!

[owenwengerd]

The answer depends on whether you're running 64-bit or 32-bit AutoCAD, and whether you have 32-bit or 64-bit Microsoft Office installed.

[masoud_123]

I'm running 64 bit Autocad and 64 bit MS access.
Thanks

[owenwengerd]

In that case there are numerous possibilities. I did a quick search and found this. You can also use the 64-bit ODBC driver, but ADO is generally a better choice.

[masoud_123]

Thank you so much. I'll challenging to it!

[masoud_123]

In that case there are numerous possibilities. I did a quick search and found this. You can also use the 64-bit ODBC driver, but ADO is generally a better choice.

and How to connect a 64-bit Autocad to 32-bit MS access database?

[Bhull1985]

That you may have issues with.
Something about Microsoft not creating 64 bit drivers for their ODCBs, you may have to use a 32bit one

[owenwengerd]

and How to connect a 64-bit Autocad to 32-bit MS access database?

That isn't possible, except possibly with commercial third party Microsoft Access drivers.

[Bhull1985]

and How to connect a 64-bit Autocad to 32-bit MS access database?

That isn't possible, except possibly with commercial third party Microsoft Access drivers.

Precisely!