Results 1 to 5 of 5

Thread: ACCESS97

  1. #1
    Star Lounger
    Join Date
    Jan 2001
    Location
    Charlottetown, Prince Edward Island, Canada
    Posts
    76
    Thanks
    0
    Thanked 0 Times in 0 Posts

    ACCESS97

    i am trying to figure out how to execute an Access macro at the same time every morning. i thought Outlook might be the obvious choice. Can anyone tell me how this might work with Outlook or any other desktop utility?
    Thanks

    ------------------
    mike
    [img]/w3timages/icons/oink.gif[/img][img]/w3timages/icons/oink.gif[/img][img]/w3timages/icons/oink.gif[/img][img]/w3timages/icons/oink.gif[/img][img]/w3timages/icons/oink.gif[/img][img]/w3timages/icons/oink.gif[/img]

  2. #2
    Silver Lounger
    Join Date
    Jan 2001
    Location
    Indianapolis, Indiana, USA
    Posts
    1,862
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: ACCESS97

    Hi Mike,

    Here's a thought: You could use the Scheduled Tasks feature built into Windows 9x (and NT, I presume). Just set an automated task to launch Access at the specified time each desired (weekday) morning. Then include the path to the access database in the command line:
    C:Program FilesMicrosoft OfficeOfficeMSAccess.exe C:My DocumentsMyDatabase.MDB

    Then just make sure you have the macro set to launch when the database is opened (Autoexec macro).This would not require Outlook to be open and shouldn't require any user intervention.

    Good luck!

    -MarkJ-

  3. #3
    Star Lounger
    Join Date
    Jan 2001
    Location
    Charlottetown, Prince Edward Island, Canada
    Posts
    76
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: ACCESS97

    Once again MARKJ has come through!

  4. #4
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Edmonton, Alberta, Canada
    Posts
    326
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: ACCESS97

    I've never tried this command line switch, but according to the online help (ask for help on command-line options) /x macroname will start a specified macro when Access starts up. So, you could use that to run your macro only when the scheduled task launches and not every time you run the database (as would be the case for the Autoexec macro).

  5. #5
    Lounger
    Join Date
    Jan 2001
    Location
    Sacramento, California, USA
    Posts
    34
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: ACCESS97

    I do exactly what Doug Martin is suggesting to run daily maintenance on a large database. I just built a simple batch file ([filename].bat)that can be run by simply double clicking from explorer, or scheduled in any application that uses a "run application" function. I used the Norton Program Scheduler that comes with Norton Antivirus for quite a while, with the path to the *.bat file and the "x/ (macroname) argument at the end. You could do it directly by supplying the path to the database too.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •