How do you link to data tables on a CD

[Pinot]

I have an Access database that I have split into two - one with the data tables ('data database') and the other with the application. I want to distribute this database on CD so that when I update the data I only have to send a new data CD and not a new install. In the application database there is an error trap that results in the user being asked to locate the 'data database' as soon as the application is opened. If I make the install put the 'data database' on the users hard drive then they can click on it and restore all the table links. If the user directs the application to the CD, the Error 3051 comes up - ...already opened exclusively ... or you need permission ...

Does anyone know of a way to get around this problem so that I can retain the 'data database' on the CD and still have the application link to it properly?

Cheers.

 

[DavidCat]

set the read-only attribute of the data MDB file before you copy it to a CD. If its not set, Access thinks the tables are updateable even when they are stored on write protected disk or CD.

 

[Pinot]

Thanks DavidCat,

I changed the attributes to "read only" on the 'data database' and tried again. I still get the message that it cannot link the tables in due to error 3051.

I'm sure there is a much simpler way of doing what I am trying to do, but as I have only just cut my teeth on this project I have made a few choices in the beginning that have resulted in a few inventive work-arounds later on.

Thanks for your help though.