Daily update-- 2nd post---no hits yet!

[waynez]

Hi
I posted this last week but got no hits!!!

I am importing a dbase file every morning. I have got it down pat doing the
process manually, but I need to have the computer do it without human
intervention every morning at 0900. Any help out there on how to automate
something like this. I think I may have to use some 3rd party software to
schedule the start but I have no idea where to start looking.

Thanks in advance for any direction given.

 

[Ken Snell]

You can set up an AutoExec macro that runs when the database is opened and
have that macro do the import for you. Note that doing this means that the
AutoExec macro will run even when you open the database manually.

Or you can create the import macro and run that macro via command line
switch when you open the database:
"C:\PathToAccess\Msaccess.exe" "C:\PathToDb\MyDB.mdb" /x NameOfMacro

Either way, you can use the Windows Scheduler to run ACCESS at the desired
time and open the database.