[AccessD] Starting Access from a command prompt

John Bodin jbodin at sbor.com
Tue Sep 18 20:54:18 CDT 2018


Having a brain cramp.  I have an access FE/BE app that people run using the full version of Access 2003.  Periodically, the FE app decompiles on a user and causes slowdowns and issues, so I have a little batch file that they can run to copy a cleaned Compiled version to their local C drive, overwriting the fault FE file.  Then they click on their normal icon that starts the Access FE from the C drive and away they go.

I am trying to make these two icons/processes into one icon.  So process would be:

Copy S:\MyApp\Compiled.mdb C:\MyApp\MyProg.mdb
C:\Program Files (x86)\Microsoft Office\Office11\MSAccess.Exe C:\MyApp\MyProg.mdb

I put both of those lines in a BAT file and they both execute just fine, however a Command prompt stays open showing "1 files copied" which I know is from the first line of the bat file.  Access then opens and person can work, but the command prompt window is still open. Once person quits out of Access, command prompt closes, which I know is because there are lines left to run in the bat file.

The above all makes sense, but I can't remember how to use either START or CMD /C or CMD /K, etc. to force the BAT file to close after it starts running Access so the person doesn't see the window.   Or what other way can this be done (I'm know it is simple, just drawing a blank.)  I know FMS has a tool to maintain FE Updates, but not sure how it works.

Thanks for any help - hope it made sense.

John

---

John Bodin
sBOR Office Systems
jbodin at sbor.com<mailto:jbodin at sbor.com>




More information about the AccessD mailing list