Open Access DB from .bat

[gpetrona]

Is it possible to open an access data base using a .bat command? I have a .bat file that combines multiple files and archives the individual files. I'd like to auitomatically start up the access data base from within that .bat file. Or, is there an easy way to import multiple files?

 

[Dennisk]

Access supports command lines usually used in shortcuts but can run in batch files. Search help for command line options.

 

[stallyon]

you can have the line:

"C:\Program Files\Microsoft Office\Office10\MSACCESS.EXE" "C:\DatabaseDir\Database MDE.mde" /user dan

which will open up the MDE database for user Dan