refreshing links to a CD-ROM

[Pinot]

I have a database that is split into two parts - one holding the tables ('data'), the other holding the application. I want to distribute this database via a CD-ROM. The CD will install all the necessary components as well as the application database, but I want it to link to the tables in the 'data' database that is to remain on the CD. By doing this, when the data is updated I only have to send out a new CD, and not a new installation. The problem I ma having is that I get "Error 3051" when I try to refresh the table links to the CD. The error tells me that the 'data' database is already opened exclusively by another user or I need permission to view its data. I am assuming this is because it is 'Read- Only' being on a CD. Does anyone know of a way around this error?

Pinot

 

[Kalin]

Was the Access db closed while you burned your CD ??

I know Excel has troubles opening a spreadsheet which has been saved but not closed and then is used on another computer. It won't open because of 'sharing violation'.

Maybe this helps....