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

:   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 2007 database, structure and data for one (big) table
del %fileRoot%-mdb-2007.zip
del %fileRoot%-2007.mdb
copy %fileRoot%-2007-empty.mdb %fileRoot%-2007.mdb
:"c:\program files\microsoft office\office11\msaccess.exe" i:\uls\master\%fileRoot%-2007.mdb /x macUpdate
"c:\program files\microsoft office\office14\msaccess.exe" i:\uls\master\%fileRoot%-2007.mdb /x macUpdate
pkzip25 -add %fileRoot%-mdb-2007 %fileRoot%-2007.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" i:\uls\master\%fileRoot%-2003.mdb /x macUpdate
"c:\program files\microsoft office\office14\msaccess.exe" i:\uls\master\%fileRoot%-2003.mdb /x macUpdate
pkzip25 -add %fileRoot%-mdb-2003 %fileRoot%-2003.mdb

: 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" i:\uls\master\%fileRoot%-2000.mdb /x macUpdate
"c:\program files\microsoft office\office14\msaccess.exe" i:\uls\master\%fileRoot%-2000.mdb /x macUpdate
pkzip25 -add %fileRoot%-mdb-2000 %fileRoot%-2000.mdb

:END