It is not MDAC issue. MDB uses Jet Engine, which is 32 bit, and will not
have 64 bit version, for sure. You may consider to upgrade your *.mdb
database to *.accdb (Access2007), then use MS Access database engine (free
download, so you do not need Access2007 installed to access data in it, just
as access data in *.mdb).
As for MySQL, it is the same as SQL Server (Express), as server database. If
you can use MySQL, I do not see why you cannot use SQL Server Express (you
do know it is free, don't you?). You only need to buy it if you have more
than 4G data for a single database, which I assume you do not, since you
want to use *.mdb (2G is its limit).
If you really want a file based database, another option would be SQL Server
CE, which is also free, and is aimed for local install and local use, but
still can be shared by multiple users.
"Rinze" <a@xxxxxx> wrote in message
news:O6mx$mJ%23JHA.4648@xxxxxx
Quote:
> Hi all,
>
> I'm in desperate need for 64bit MDAC components. I need to access an
> (Access)MDB file from 64bit program.
> Everywhere I look it tells me to compile it as a 32bit program because MS
> doesn't provide 64bit MDAC components. But these messages are usually
> pretty old. Compiling as 32bit only is not an option as I'm writing a
> plugin for AutoCAD and 64bit AutoCAD doesn't accept 32bit plugins.
>
> I've looked at using SQLExpress but that doesn't allow me to mount a db
> from a network drive, it can only mount local files. I'm not going to tell
> the customer to buy SQLServer @ thousands of dollars just to use this
> plugin.
>
> I'm about to point my arrows at MySQL unless a 64bit version of MDAC is
> available. So does it exist and if so, where do I download it.
>
> Rinze van Huizen