I have a batch file that used to start Access successfully via the task scheduler. But it suddenly stopped working. I can still open Access manually and it compacts on close as per its settings. When I try to compact it manually I get the message it is opened by user Admin on my machine. Nothing is opened according to task manager.
Batch file code
The confusing thing is this used to work.
the database size is 1.43 gig, still below the 2 gig limit, so i think the size is not an issue.
Batch file code
Code:
@echo off
C:\Users\Me\Desktop\REPORT.accdb
the database size is 1.43 gig, still below the 2 gig limit, so i think the size is not an issue.