Hi all.

Is it possible to read an Access database that is on a CD drive?

I'm developing an application that will read an access database from
CD.  The database is built to be query only, I do not intend to try to
write back to it.

Nonetheless, the microsoft JET engine complains and puts up a message
box:
  "The Microsoft Jet Database engine cannot open the file
'z:\maryland.mdb'.  It is already opened exclusively by another user, or
you need permission to view its data."

The z: drive is my CD.

My application is written in C++ and uses a CDaoRecordSet (recset).

I call the open as follows....

    recSet.Open(dbOpenSnapshot, NULL, dbReadOnly|dbForwardOnly);

Are there other flags I need to specify to open the access database
readonly?

Thanks,
   Paul

The trick is to include a zero byte .ldb file on the CD with the same
name as the MDB.  Although test this trick first using a CD-RW.   Also
a command line option such as /EXCL or /READ or somewhat similar.
also needs to be set.   There are also reports that this technique
doesn't work in A2002.

Tony
----
Tony Toews, Microsoft Access MVP
   Please respond only in the newsgroups so that others can
read the entire thread of messages.
   Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm