Hello, I've assumed an Access database that calls a batch file nightly that contains:
ECHO OFF
c:
CD\Program Files\Microsoft Office\Office11
Msaccess.exe "J:\Share\MS Acces Project\Dat_be.mdb" /x Macro1
Msaccess.exe "J:\Share\MS Acces Project\Dat_be.mdb" /Compact
Msaccess.exe "J:\Share\MS Acces Project\Dat_fe.mdb" /Compact
When I open Data_be.mdb and go under Macros, Marcro1 doesn't exist. Am I looking in the wrong place or where else might the macro exist?
I've searched the Forum and I'm stumped, thanks for your help.
ECHO OFF
c:
CD\Program Files\Microsoft Office\Office11
Msaccess.exe "J:\Share\MS Acces Project\Dat_be.mdb" /x Macro1
Msaccess.exe "J:\Share\MS Acces Project\Dat_be.mdb" /Compact
Msaccess.exe "J:\Share\MS Acces Project\Dat_fe.mdb" /Compact
When I open Data_be.mdb and go under Macros, Marcro1 doesn't exist. Am I looking in the wrong place or where else might the macro exist?
I've searched the Forum and I'm stumped, thanks for your help.