Job to open an Access database

[bobfin]

We are running SQL 2000 Enterprise and MS Office 2003. We've defined a linked server to an Access database on our network. When the database opens, it runs a multi-step macro and then closes. We want this macro run every night, so how do we create a job to open this database?

 

[pbaldy]

I would just run it from Windows Scheduled Tasks.

 

[SQL_Hell]

Hi there

Was does the macro do?
I am wondering if there is a way you can get rid of the Macro all together