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 B" <Guy (E-Mail Removed)> wrote in message
news:ED3E9478-A7C7-47BA-B770-(E-Mail Removed)...
>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.
>

Guy B wrote:
> 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.

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.

--
Joseph Meehan

Dia duit

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.

--
Phillip Windell [MCP, MVP, CCNA]
www.wandtv.com





"Guy B" <Guy (E-Mail Removed)> wrote in message
news:ED3E9478-A7C7-47BA-B770-(E-Mail Removed)...
>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.