using a batch file to open a access database

[at51178]

HEY GUYS

I would like to know how to open up a access database using a batch file.

i thought I could just type
the name of the path and the file name for example

c:\mydatabase.mdb

 

[JeremyNYC]

Actually, you've got to call Access, the mdb file, and the workgroup file (unless you're using the default).

Here's a sample from one of mine:
"C:\Program Files\Microsoft Office\Office\msaccess.exe" "C:\BnkRecSW\Prdction\Tools\BnkRecFE.mdb" /wrkgrp G:\HOME\BANKREC\BnkRecSW\Prdction\Tools\BnkRec.mdw

It's all one line. It will, of course, require different directories, depending on how your system is set up.

Also, if you're interested in looking into what else you can do with batch files and Access databases, check out the Deploying Databases article on my website.

Jeremy ==
Jeremy Wallace
AlphaBet City Dataworks

http://www.ABCDataworks.com

Affordable Development, Professionally Done

Please post in the appropriate forum with a descriptive subject; code and SQL, if referenced; and expected results. See thread181-473997 for more pointers.

 

[kewo99]

You can use the command START to avoid entering the path/filename of the Access executable.

Start <Optionalath/msaccess.exe> c:\mydatabase.mdb

This has the added benefit of opening the application in a new window so that the DOS window closes. If you run the batch file from a hyperlink, the DOS window stays open.

Ken