Re: DBI Access windows question

Microsoft Access only allows one process to have the database file open. This is done for safety since Jet (the database engine) can corrupt databases when accessed they are written simultaneously by different processes.

One solution is to work with copies of the database. Copy the database file, modify with your own processes, and copy it back to the main file.

The proper solution is to ditch Jet database engine. You can use SQL Server (or MSDE) with Access. This will give you much more reliability.

Comment on Re: DBI Access windows question

Replies are listed 'Best First'.
Re: Re: DBI Access windows question by Anonymous Monk on May 14, 2004 at 18:55 UTC
ok, thanks, I've made a "user" copy. I was able to have multiple access on another windows machine, and don't recall installing SQL server. Does MSDE come with the system?	[reply]
Re: DBI Access windows question by Errto (Vicar) on May 15, 2004 at 00:14 UTC
Last I checked MSDE was standard with Office 2000 Professional and above. But be very careful of the licensing requirements, as they are arcane and bizarre. Frankly, if it were me I'd use MySQL over ODBC, but that's just me.	[reply]