Can I make an Autorun CD with a MS Access?

Hi:
I have a MS Access program and I store it in a cd.
I want to make my access program start once I insert the CD to the CD rom
please
Mohammad Alsolaimanapplication programmerAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Rey Obrero (Capricorn1)Commented:
before anything else, iwant to let you know that the db application you placed in a cd rom will be read only
0
pitonsCommented:
Easy way:
create file "autorun.inf"
in a cd root folder and add following:

[AutoRun]
open=path to access.exe

there are many other options but these are basic for autorun to work.
You can read more:
http://www.phdcc.com/shellrun/autorun.htm
and if you don't wan't to waste time learning here is program to do ir for you
http://autorun.moonvalley.com/
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Rey Obrero (Capricorn1)Commented:
it will not open your db application stored in the cd rom, it will fail to create the .ldb file
0
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

Mohammad Alsolaimanapplication programmerAuthor Commented:
pitons:
do you mean "C:\Program Files\Microsoft Office\OFFICE11\access.exe"
if so
how come it will open my database?
capricorn1:
my access program is for display only, it contains thousands of records and some easy search methods only.
second: i always run ms access from CD, it dose open, but there is a message tells "this database is fore read only"
please help me continue this matter.
0
Hamed NasrRetired IT ProfessionalCommented:
Try this example: Modify the names to reflect your issue.
burn the following files to CD.
db1.mdb     ' this is your mdb file
autorun.inf,    content:
      [autorun]
      open=db1.bat
db1.bat,  content:
     db1.mdb

0
Mohammad Alsolaimanapplication programmerAuthor Commented:
Yes , it works good thank u very much hnasr
But , there is a problem with it
It is open the black dos prompt windows, which is not nice to give it to the customer
This way
I think a Compiled C program is an .exe file
Can any one here write a small C program do the same as the "hnasr batch " do
Please help
0
pitonsCommented:
as I wrote before...
see this link:
http://www.phdcc.com/shellrun/autorun.htm
exactly solution u need:
download that shell exe install prog
0
Hamed NasrRetired IT ProfessionalCommented:
M_SOLAIMAN,
You can use a VBScript file
Try this example: Modify the names to reflect your issue.
burn the following files to CD.
db1.mdb     ' this is your mdb file
autorun.inf,    content:
      [autorun]
      open=db1.vbs
db1.vbs,  content:
    Dim oShell
    Set oShell = WScript.CreateObject ("WSCript.shell")
   oShell.run "db1.mdb"
   Set oShell = Nothing
0
Hamed NasrRetired IT ProfessionalCommented:
I know, it does not work!
0
Hamed NasrRetired IT ProfessionalCommented:
Ok M_SOLAIMAN,
Try this.
   Decompress the file
   change autrun.txt to autorun.inf
   burn contents to a CD.
I tried it ant it works.
You may need to modify the database file name (db1.mdb)  in the ar.vbs script file.
ar-folder.zip
0
Hamed NasrRetired IT ProfessionalCommented:
The application ar.exe is written in Visual Basic. It runs the ar.vbs file.
0
Mohammad Alsolaimanapplication programmerAuthor Commented:
i do change the vbscript file
how can i recompile it again please?
0
Mohammad Alsolaimanapplication programmerAuthor Commented:
i did not notice your latest comment
i'll try it now
0
Mohammad Alsolaimanapplication programmerAuthor Commented:
thanks to all of you
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.