Access DB application fails from CD

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a full Access application that works fine on from my built in drive
but there has been a request to have the application run from a CD. Burning
it to CD is fine and having the DB as read only is fine but for some reason
the SQL queries do not work. The call seems to go out but always returns an
empty recordset.

I will look again but I am quite certain that I did not put in absolute
paths in the code as the same DB works fine on another drive as well as from
a netwrok drive.

I quess the real question is if an Access application can be run from a CD.
 
When a database is opened, file locking is controlled by a locking file.
When you open an .mdb file, Access creates and opens an .ldb locking file. I
believe that this file has to be created in the same directory as the .mdb.
If so it is not possible to run the tables part of the database from a CD.
If you have a split database it might be possible to run the front end from
a CD.
 
Guy said:
I have a full Access application that works fine on from my built in
drive but there has been a request to have the application run from a
CD. Burning it to CD is fine and having the DB as read only is fine
but for some reason the SQL queries do not work. The call seems to go
out but always returns an empty recordset.

I will look again but I am quite certain that I did not put in
absolute paths in the code as the same DB works fine on another drive
as well as from a netwrok drive.

I quess the real question is if an Access application can be run from
a CD.
Click to expand...

CD's by nature are read only. Access needs read write delete and create
access.

You should be able to copy the file to your HD and change the read only
property to read/write and work with it that way.
 
A temporary file is created in the same folder as the MDB file when it
opens. It cannot create this file on a CD. Copy the file from the CD to
the HD and it will probably run fine.
 
Back
Top