See comment inline.
"Rinze" <a@xxxxxx> wrote in message
news:umTWQIV%23JHA.2872@xxxxxx
Quote:
> 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. There is not much different between SQL Server, SQL Server Express,
regarding your need. You seems mistakenly thinking that somehow full SQL
Server allows you place data file on a network drive, hence the "@ thousands
of dollar...".
If your app is only meant for single user to use your app, why you have to
place SQL Server's database file (*.mdf) on network share? If it is meant to
be shared by multiple users, the SQL Server, or SQL Server Express, or MySQL
can be installed on any networked computer. I really do not understand why
the data file of a SQL Server (Express) has to be on a mapped network drive
in your case.
Quote:
>
> 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