create setup for a MSdb Access

[bassy]

dear members,


I have a database sbn.mdb which I've branded on a CD-ROM. For its excecution it is necessary always that it is installed with the following conditions:

1- create a directory C:\Competition and to copy the database in this directory


2-un under-repertoire [ B]C:\Competition\Images [/B] and to copy there all the logos which are used in the application.

Now I would like to know if it is possible in VBA to create a setup from which one can launch the automatic installation so that both steps explained above must not be done manually.

In other words when one insert the CD-ROM in the reader that the installtion launches out automatically or although one can do it by selecting the CD-ROM reader and then setup(clicking). I work with MSAccess 2000 and VBA

thank you in advance for your answer

 

[Nero]

Why not try a batch file to create the folder and then copy the db.
Then create your own autorun file to run the batch file.
I have done something similar with an autorun file.

 

[bassy]

Thank you Nero replaying me

but I don't know how to create this batch file ..

I need more information, may be if you can give me an example it wille help me better to solve the question..

any idea wille be grateful

 

[Nero]

Sorry for not replying sooner.

Copy the 2 ziped files to your CD and give it a try.

 

[bassy]

Thank you Nero replaying me..

Your idea is indeed very logical I've tried like explained .
But after inserting the CD-ROM in the reader, it'doesn't create the directory, so it doesn't work.
I use Nero burning program onder win XP...

so any idea to solve this probleme will be grateful

 

[Nero]

I'm using Windows 2K and Nero burning software and it works everytime the CD is inserted.

 

[bassy]

Thank you Nero replaying me..my probleme is the following:


Copy D:\sbn.mdb C:\Competition

but my CD-ROM reader is E:\ and not D:\ I have chnged

Copy D:\sbn.mdb C:\Competition into

Copy E:\sbn.mdb C:\Competition , it works

but I want it to work for every CD-ROM reader so to make it independant of the CD_ROM reader.

any help is gratiful

 

[chewy]

try one of these free set up packages

http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=47118&highlight=installation

Should do what you need. Setup2Go seems the best

 

[bassy]

Tank you all of you for your replies...it works with the following:

md C:\ Competition
cd competition
md Images
copy *.mdb c:\Competition\*.*
copy .\images\*.* c:\Competition\Images\*.*

now I want to start the database from C:\ after the installation
To do it I've added the following DOS command

C:\Competition\sbn.mdb

buyt it does'nt start the database..

any idea will be helfull

 

[Nero]

Are you getting any error messages or is it just not opening?

 

[bassy]

thank you all for your replies..

I'm not getting any error..
it's not just opening..