Norman Yuan wrote:
Quote:
> 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.
>
>
Thanks, I will look into Access2007, but since I don't have that installed
here (just 2003) I think that's going to be a problem.
As fas as SQLExpress is concerned. Yes I know that it's free. That's why it
was the 1st thing I tried when I ran into this problem. This created a new
problem. SQLExpress can't mount files (*.mdf) located on a network share
(UNC or mapped drives). You can only mount files from local drives. MySQL
is more like SQLServer than SQLExpress.
I've also looked into SQL Server Compact Edition. But either I'm missing
something or it's too "compact" for my needs. I managed to mount the DB for
it in the SQL Server management studio and I was able to create tables. But
that's where it ended. I couldn't open the table to edit the data. I
couldn't define relations between the tables. I updated the CE tools for
VS2005 and there I could enter data into the tables, but still I could not
define relations.
Rinze