Installing an Access database

[WFS]

Hello,

let's suggest I have a complete Access Database, which I distribute on a CD-ROM to different users.
Is it possible that when opening Access from the CD-ROM, the program searches for the hard disc on the computer, creates his own file and path and copies everything from the cd-rom to this file. During this proccess we like to keep the user informed of what is happening... + give him a result and instructions to open and work on the database, stored in the new created file.

Is this possible in VBA?

MANY THANKS,

WFS

 

[mdmilner]

Microsoft Office Developer Edition includes a Package & Deploy wizard.
There's also a runtime version of Access available (unlimited license).

You'll want the version for your particular flavor (version) of Access.

VBA runs inside Access. You'd have to at least open the database to get it to execute any code, but once it's running, you can pretty much do whatever you wish.

I'm not very familiar with any possible free/shareware deployment packages available.

Mike