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.E XE" "D:\www\exponhc.com\Nation alHurrican eConferenc e.mdb" /X Macro_DeleteUnpaidExhibito rs
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.E
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Forced accept.
Computer101
EE Admin
Computer101
EE Admin
make sure you don't have the "compact on close" option set for your application.