Scheduling Access Modules

S

Scott McDaniel

Not sure what you mean. You can activate an Access database by using this
syntax:

"PathToAccess" "PathToDatabase" /wrkgrp "PathToWorkgroup" (last only if
necessary)

You may not need to include the "PathToAccess" in the command, but it's a
habit for me.

In your database, run code in either the Autoexec macro OR use a startup
form that automatically runs code.

Actually accessing the task scheduler from VBA is a trick, however. I looked
into it, and actually found some modules that appeared to work (google on
"vb add task") but were quite complex. I ended up buying a small control
that helped matters out, but I've never done if from Access, only VB.
 
Top