Batch File to Copy DB

[Sharon]

Hello:

I've created a batch file that copies a backend copy of my
db to a users hard drive. I'd like the same batch file to
open the file that's on the hard drive. I'm not too
familiar with writing batch files. Does anyone have an
example of what the command line should be to open a file.

TIA,
Sharon

 

[Scott Gardner]

Add a line to your batch file that looks something like this:

"c:\Program Files\Microsoft Office\office11\msaccess.exe" "c:\myfile.mdb"

Including the (")s.

Where 'c:\Program Files\Microsoft Office\office11\msaccess.exe ' is the path
to where Access is installed on your machine and 'c:\myfile.mdb' is the path
to the file you want to open.

Scott Gardner
Access Development
Microsoft Corporation