Products / DBWConsole

DBWConsole is the tool to execute the sql scripts in MS Access database.

It was created to execute scripts produced by DbWeigher and DBWScript, it is included into the installation packages of these products.

To execute the script, you can open the sql file or copy the script into the edit window using the clipboard. Then you can open the mdb file or create a new mdb file. Use File > Open Mdb to open the existing database or create a new one File > Create Mdb.

DBWConsole can be used with the command line parameters. It allows you to run it using the build system like ant, nant, msbuild and so on.

Usage: DBWConsole <sql file> <mdb file> [option1] [option2] ...

/c	- create the empty mdb file
/o	- delete the old mdb file
/e	- show an error message in the console instead of the message box

If you start it from the command interpreter (batch file), you may need to use start /wait to force cmd.exe to pause. E.g.
start /wait DBWConsole script.sql database1.mdb