automate access macro

tring007
tring007 used Ask the Experts™
on
I need to run a access macro on a daily basis and would like to automate the procees, I mean that it should run automatically at a particular point of time. Any ideas on how to accomplish it. I also like to supress the alert messages that pops up when a data manupulation occurs, these alerts should be suppresed only when the macro is run in automated mode????

Operating system : Windows 95/XP
Novell client installed version???
Microsoft Access 97

Where can I download Acess 97 runtime or how do I create the runtime using ODI?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
use the timer event on your opening (main) form of your app. Have the event compare the current time to the time you want to run your macro.

Also, use
docmd.setwarnings false
 to turn off the alert messages

and
docmd.setwarnings true

 to turn it back on after you run the macro

Author

Commented:
Thanks for provinding answer on supressing the warning messages. For the automation, I am looking for certain netware scheduler where in I can shedule this task. The task should run during night time.
Commented:
I use the Windows NT/2000/XP scheduler to run DOS batch jobs that contain statments like this:

"C:\Program Files\microsoft office 97\Office\MSACCESS.EXE" "G:\PSN_SRC\Member Downloads\PMC Members\Current PMC.mdb" /x "Delete Data Tables"

/x means to run the macro.

End each macro with quit and the batch file will run the next statement without pausing.

You may need to know all of the startup switches, e.g. /compact to compact the database.

This works with Access 2000 and 2002 as well.

Commented:

No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:
 - Answered by: dleongvp  
Please leave any comments here within the
next seven days.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER !

Nic;o)

Commented:
Finalized as proposed

modulo

Community Support Moderator
Experts Exchange

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial