Trying to use WinCron to schedule automatic repair of a Microsoft Access Database but cannot get it to work. MS access has command line parameters like /Repair that you can start it with.
Tried:
-command -shell C:\test2.mdb /Repair
-command -shell "C:\test2.mdb /Repair"
-command msaccess c:\test2.mdb /Repair
Get:
Failure during shell of: C:\test2.mdb (-shell C:\test2.mdb /Repair). --The system cannot find the file specified.
the path and filename are correct, so not sure what the error message means.
Then tried:
-command "C:\Program Files\Microsoft Office\Office10\msaccess.exe" c:\test2.mdb /Repair
What that does is starts MS Access and tries to open a Database called Files\Microsoft.mdb. So the paths are getting messed up.
Help?