Make a Setup file

A

AndreasM

I have a database and i must give it to my proffessor but i dont like to give
mdb file. I would like to give a Setup.exe file which create my database
folder and setup my database. How I do that? Thanks for your time
 
A

Arvin Meyer

I do it with batch files. One of them might look like this:

; This batch file is to install the Time Control Database
; It will also update any existing files by overwriting them

md c:\FolderName
md c:\FolderName\Utilities
copy \\ServerName\FolderName\OpenDBs.mdb c:\FolderName\Utilities
xcopy \\ServerName\FolderName\TimeControl.mdb c:\FolderName /y
xcopy \\ServerName\FolderName\WorkTicket.dot c:\FolderName /y
xcopy \\ServerName\FolderName\Quote.dot c:\FolderName /y
xcopy \\ServerName\FolderName\Reports.mdb c:\FolderName /y
copy \\ServerName\FolderName\OpenDbs.lnk "%userprofile%\Desktop

substitute your server and foldernames. The above, creates 2 folders (one
inside the other) and copies 3 databases and 2 Word templates to the proper
places. Then it copies without overwriting the link to the user's desktop
using the user's profile environment variable to find the desktop.

If you'd like to spend some money, you can buy and use the Developer's
Edition to install a runtime copy of Access.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Top