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 at (no spam) 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

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 at (no spam) 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

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 at (no spam) 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

Michel Posseth [MCP] wrote:
Hello Rinze


Access is a dead end in your situation , the only good substitute would
be to use SQL server CE wich is file based and is XCOPY deployable it
has all the good stuff that ACCESS had from a developers perspective


HTH

Michel Posseth


I kinda figured it was a dead end In Access I can define relations that
enforce referential integrity (i.e. I delete/update a record from one
table and it deletes/updates the related records in another table
automatically). That seems to be missing from SQLServerCE. I haven't found
a way to define relations (if there is, please let me know). So in that
sense it doesn't have all the good stuff Access had/has.

Rinze

PvdG42 wrote:


A quick Google Groups search yielded numerous references to MDAC 2.8. I
suggest you do the search and follow the links. Good luck.

I didn't see any mention that MDAC 2.8 was 64bit, but I will look into it.
We have a Vista64 here and it's all up to date but it still doesn't open
it. Seems the Jet Engine is the culprit. I thought the Jet engine was
included in the MDAC, but apparently they don't do that anymore. And the
Jet engine is 32bit only. I guess it's bye bye mdb.

Rinze

If you really like ACCCESS and need to use it on a 64 bit system the
only other solution is to built your project strict form 32 bit in that
case your app will run on a 64 bit system in the WOW layer
and can access the 32 bit drivers if they are installed on the system .
I have done this in the past and it worked flawless

The only other solution is to use a database with a 64 bit driver SQL
server , SQL server CE , or another nice free alternative Firebird DB
wich has a free full featured DB and a SQL CE clone ( although the
Firebird version was there first ) the firebird XCOPY version however is
not protectable on file level and SQL CE is ( password protect the DB
to protect contents from uniauthorized access )
But for the rest the firebird version is also a great product with all
sorts of features http://www.firebirdsql.org/


For the rest i have never found a good free alternative, for the
security feature i choose SQL CE as this was verry important to me at
that time

Hello Rinze

use foreign key relationships and cascade deletes / updates for this
purpose.

with SMS you can do this graphicly but it is also possible with script
http://technet.microsoft.com/en-us/library/ms173393.aspx

HTH

Michel

Michel Posseth [MCP] wrote:

If you really like ACCCESS and need to use it on a 64 bit system the only
other solution is to built your project strict form 32 bit in that case
your app will run on a 64 bit system in the WOW layer
and can access the 32 bit drivers if they are installed on the system . I
have done this in the past and it worked flawless

It's not that I'm married to ACCESS. But for this application it was
simply the easiest... Until I tried a 64 bit version. 32bit only is not
an option because I'm making a plugin for AutoCAD and you can't load a
32bit dll into 64bit AutoCAD. Believe me, I tried it.

The only other solution is to use a database with a 64 bit driver SQL
server , SQL server CE , or another nice free alternative Firebird DB
wich has a free full featured DB and a SQL CE clone ( although the
Firebird version was there first ) the firebird XCOPY version however is
not protectable on file level and SQL CE is ( password protect the DB to
protect contents from uniauthorized access )
But for the rest the firebird version is also a great product with all
sorts of features http://www.firebirdsql.org/


For the rest i have never found a good free alternative, for the
security feature i choose SQL CE as this was verry important to me at
that time



Hmm Firebird, didn't think of that I will check it out, thanks.

Rinze

I thought it didn't accept remote connections (I thought that was one of
the things that made it 'express').

Michel Posseth [MCP] wrote:
Hello Rinze

use foreign key relationships and cascade deletes / updates for this
purpose.

with SMS you can do this graphicly but it is also possible with script
http://technet.microsoft.com/en-us/library/ms173393.aspx

HTH

Michel


In SMS I can define the relations graphically on our full SQL server and
in my SQLExpress. But when I open the SQLCE db I can't for some reason.
But I have made a mistake regarding SQLExpress. I thought it didn't accept
remote connections (I thought that was one of the things that made it
'express'). But seeing it does accept remote connections, that solves my
problem.

Rinze