Link to home
Start Free TrialLog in
Avatar of dindryte
dindryte

asked on

Use Windows Scheduler to open Access 2k3 DB run macro and close the db

I am having trouble with the Windows Scheduler and Access 2k3.
I have built a task using the info below and the db opens deletes records and seems to close without error.
However, the lock file for the database never closes, and this causes the web application to fail when connecting to the database.
Is there an extra step required to ensure the database is closed?
Thanks for any and all help!

"D:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE" "D:\www\exponhc.com\NationalHurricaneConference.mdb"  /X Macro_DeleteUnpaidExhibitors
ASKER CERTIFIED SOLUTION
Avatar of puppydogbuddy
puppydogbuddy

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of puppydogbuddy
puppydogbuddy

ps: Something I just thought of...
make sure you don't have the "compact on close" option  set for your application.
Forced accept.

Computer101
EE Admin