:   export-msaccess.bat
:   batch file to populate an MS-ACCESS database from a MySQL database
:   n6lhv@arrl.net
:   created:  20-December-2004
:   updated:  21-December-2004

:   functional dependencies
:     -the ODBC driver (e.g., MySQL Connector/ODBC) has been installed correctly
:     -the MySQL Service is running
:     -all of the correct database files have been successfully generated

SET fileRoot=%1

: MS-Access 2000 database, structure and data for one (big) table
del %fileRoot%-mdb-2000.zip
del %fileRoot%-2000.mdb
copy %fileRoot%-2000-empty.mdb %fileRoot%-2000.mdb
"c:\program files\microsoft office\office11\msaccess.exe" e:\uls\master\%fileRoot%-2000.mdb /x macUpdate
pkzip25 -add %fileRoot%-mdb-2000 %fileRoot%-2000.mdb

: MS-Access 2003 database, structure and data for one (big) table
del %fileRoot%-mdb-2003.zip
del %fileRoot%-2003.mdb
copy %fileRoot%-2003-empty.mdb %fileRoot%-2003.mdb
"c:\program files\microsoft office\office11\msaccess.exe" e:\uls\master\%fileRoot%-2003.mdb /x macUpdate
pkzip25 -add %fileRoot%-mdb-2003 %fileRoot%-2003.mdb