file that automatically runs queries to update tables

  • Thread starter Thread starter PRAV
  • Start date Start date
P

PRAV

Hi, how can i implement a file on my pc that automatically runs queries
at 10pm everyday in order to update few tables in my ms access 97
database.
 
Use the Schedule Task facility in windows that will open the database and
run the Autoexec macro. But first create an Autoexec macro that will run
the queries and quit the database.

This works for a stand-alone but on the network you may need a batch file
that will do the same as the task scheduler. I have tried leaving a
workstation
connected to the network to test this operation as it leaves an opportunity
for security breaches etc.
 
I think a batch file will me more appropriate as its transportable. In
my ms access 97 application i have already an autoexec which performs
few activities. This means that everything a user opens the ms access
application its gonna run that queries which take almost 1 hours to
complete. Could you please help how to make a batch file with the
running of the querries at a specific time everyday. cheers
 
Instead of the autoexec macro, use a commandline switch to specify a macro:
"c:\path\to\access.exe" "c:\path\to\MyDatabase.mdb" /x MyMacroName

Barry
 
Back
Top