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

Posted on 2007-10-15
Last Modified: 2008-03-23
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\\NationalHurricaneConference.mdb"  /X Macro_DeleteUnpaidExhibitors
Question by:dindryte
    LVL 38

    Accepted Solution

    This appears to be a bug.  One interim solution is to  use another scheduler, the free Handy Access Launcher (HAL) instead.  See the accepted answer to this link.

    LVL 38

    Expert Comment

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

    Expert Comment

    Forced accept.

    EE Admin

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Enabling OSINT in Activity Based Intelligence

    Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

          Install BugTracker on Windows 2008 server Step 1:  Install windows 2008 server 32 bit OS and configure IIS. Step 2:  Install SQL server ( SQL server 2005 or SQL server 2005 Express edition. The installer for 2008  version isn’t very f…
    A publishing tool, a Version Control System, or a Collaboration Platform! These can be some of the defining words for the two very famous web-hosting Git repositories: Bitbucket and Github. Git is widely used amongst the programmers and developers f…
    What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
    With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

    761 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    8 Experts available now in Live!

    Get 1:1 Help Now