Automated Routines

[Guest]

I need to create an automated routine in the database that automatically
deletes records before a certain date.
Would I use macros or some form of query?!?

 

[Nikos Yannacopoulos]

A Delete query is what will do the job; an Autoexec macro to run it
everytime you open the database might be a convenient trigger to run it.

HTH,
Nikos

 

[Guest]

If it needs to happen on a regular schedule you can always create a macro
inside the Access database to do it and then use Windows task scheduler to
run a batch file that will in turn open the database and execute the macro
that will delete the desired records at a preset time every day, week, or
month etc....
If you need more help with this let me know.

- SPARKER

 

[Guest]

hi..i have the same problem. I have an excel file contains pivot table and
I want to schedule a job like for example every friday morning to
automatically run the macro that will refresh the pivot table. Pls.
take note that the excel file has a password before opening. How can I do
that?
Thanks and thanks in advance.

 

[Guest]

I can open a db with a batch file but what's the syntax to execute a macro?