automating process

[Guest]

Hello,

I have an Access database containg a macro that runs queries and populates
tables. I would like to find a way to schedule Access to start at 6 am, run
the macro, and close wthouth human intervention. How do I accomplish this?

Cheers,
Michael Lindekugel

 

[Guest]

You can use the Windows Scheduler to automatically open the database. You can
also create an AutoExec macor that will run your code.

You can also include a Docmd.Quit a the end of your code that will close the
database.

 

[Guest]

You can use the Windows Scheduler to automatically open the database. You can
also create an AutoExec macor that will run your code.

You can also include a Docmd.Quit a the end of your code that will close the
database.

 

[Pieter Wijnen]

better to use vb/vbscript And DAO execution

HTH

Pieter

 

[Pieter Wijnen]

better to use vb/vbscript And DAO execution

HTH

Pieter