TheSwamp

Code Red => AutoLISP (Vanilla / Visual) => Topic started by: masoud_123 on January 01, 2014, 06:18:43 AM

Title: Visual lisp and MS access 2010 64 bit
Post by: masoud_123 on January 01, 2014, 06:18:43 AM
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!!
Title: Re: Visual lisp and MS access 2010 64 bit
Post by: owenwengerd on January 01, 2014, 09:18:04 AM
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.
Title: Re: Visual lisp and MS access 2010 64 bit
Post by: masoud_123 on January 01, 2014, 12:37:06 PM
I'm running 64 bit Autocad and 64 bit MS access.
Thanks
Title: Re: Visual lisp and MS access 2010 64 bit
Post by: owenwengerd on January 01, 2014, 04:07:51 PM
In that case there are numerous possibilities. I did a quick search and found this (http://adndevblog.typepad.com/autocad/2013/04/using-autolisp-to-read-an-access-database-via-ado.html). You can also use the 64-bit ODBC driver, but ADO is generally a better choice.
Title: Re: Visual lisp and MS access 2010 64 bit
Post by: masoud_123 on January 02, 2014, 02:29:54 AM
Thank you so much. I'll challenging to it!
Title: Re: Visual lisp and MS access 2010 64 bit
Post by: masoud_123 on January 02, 2014, 03:07:15 AM
In that case there are numerous possibilities. I did a quick search and found this (http://adndevblog.typepad.com/autocad/2013/04/using-autolisp-to-read-an-access-database-via-ado.html). 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?
Title: Re: Visual lisp and MS access 2010 64 bit
Post by: Bhull1985 on January 02, 2014, 08:21:58 AM
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
Title: Re: Visual lisp and MS access 2010 64 bit
Post by: owenwengerd on January 02, 2014, 10:07:20 AM
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.
Title: Re: Visual lisp and MS access 2010 64 bit
Post by: Bhull1985 on January 02, 2014, 01:01:17 PM
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!