Is it Possible to Have access App Autorun When Inserting A CD

[Guest]

I have a MDB that I created and it has a startup form. However, the database
hyperlinks to some sensative documents So I removed the files from the hard
drive and then changed the drive letter in the function so It would call up
the files properly. So I went ahead and decided to compy the MDB file also
to the CD since I won't be writing anything to the tables anyhow because I
already compiled the file locations or path in the tables. So it got me to
thinking about Autorun that is on some of the applications I have installed
in the past.

Question: When inserting my App into the CD-Rom can I have it automatically
start up. I may be posting in the wrong newsgroup but I thought someone has
done this before and made it work. Thanks.

 

[Guest]

Hi Brian,

I don't know if this is possible. CD's that feature autostart capability
often times have a text file named AUTORUN.INF in the root folder of the CD.
If you have a rewriteable CD--so that you can try different variations in
case the first attempt fails--try creating this text file with NotePad. It
should include an Open line, and an optional Icon line. Try the following:

AUTORUN.INF (Filename)

OPEN=msaccess.exe "DatabaseName.mdb" /ro
ICON=YourIconFile.ico


Again, I don't know if it will work, but you've got nothing to lose by
trying. One possible glitch, if this does actually work, is PC's that have
more than one version of Access installed. In that case, the first copy of
msaccess.exe that is found will be used to open your database. If there is
any chance of having Access 97 installed on a given PC, then you might want
to try converting your app. to A97 first, if possible.


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

 

[Guest]

I will give it a shot. Thanks, Since this is only for personal use, It will
only be on my computers running Access 2003. Will get back with you in this
post and let you know the results after I follow your instructions. Good
point, during testing use re-writable you at leased saved me a few bucks.