• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 503
  • Last Modified:

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
0
Mohammad Alsolaiman
Asked:
Mohammad Alsolaiman
  • 5
  • 5
  • 2
  • +1
6 Solutions
 
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
 
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
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy 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
 
hnasrCommented:
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
 
hnasrCommented:
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
 
hnasrCommented:
I know, it does not work!
0
 
hnasrCommented:
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
 
hnasrCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

  • 5
  • 5
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now