VB read MS Access database on CD

[gallardo]

Running VB 5 & MS Access97 using DAO.
I have an Access database on a CD with a VB front-end. When I execute the application I get an error 3051 "database in use exclusively by another user or you need user permission to read the database" (something like that). I have removed all adds and updates from the VB code.
I have turned off all update and write permissions in the database.

The application works fine is the database is on my hard disk and the Read-Only property on the database is turned off.

Thanx, Al

 

[Morpheus1981]

Two things first: check if ur database is protect by a password because if it is u need to set System security to connect form VB and U cannot modify information that is on a CD - ROM.....
ROM:
R = Read
O = ONLY
M = Memory