How to create an auto run CD with an access database

[DMI]

How to create an auto run CD with Our Company has created a beautiful Access
Database with information for our customers. We would like for the Access DB
to start automatically once the customer inserts the CD into any computer.
We would like to setup the CD to run all of the access engine utilities from
the CD itself. In other words we would like to have a self executed Access
database CD Media so the utility on the CD will have everything it needs to
execute the DB as soon as the CD is inserted on the drive.

Any ideas how to accomplish this will be much appreciated.

Thank you in advance for your assistance with this project! an access database

 

[Douglas J. Steele]

What do you mean by "access engine utilities"?

Access must be installed on the user's machine. There's no way around
that...

 

[Daniel Pineault]

Sadly, this can't be done. Access need to create a ldb lock file when it
runs... amongst other things, and it cannot do so on a CD/DVD.

You could, however, do it with a USB key.
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.

 

[Douglas J. Steele]

Not sure about that Daniel. If you specify Read-only and Exclusive, Access
doesn't bother with a locking file.

 

[Daniel Pineault]

Thanks for the info Douglas.

If that were the case, how would it handle creating queries on the fly?
Would it need the ability to write to the media or would it do it in memory?
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.

 

[DMI]

What I mean by access engine (MS Jet database engine) utilities is the
combination of programs and files that allow access to fully run on the
computer from the CD and this will allow the database to open.

 

[Douglas J. Steele]

I believe it just does it in memory, or else writes to wherever TEMP (or is
it TMP) points.

 

[Douglas J. Steele]

As you've been told, it's not possible.