Database Scheduler

[jgelpi16]

I currently have a database that simply has to be open to kick off my scripts and such. I would like to put this on an automatic scheduler so I would not have to physically touch the DB to have the code run. Any suggestions? I am using Access 2007

[pbaldy]

The simplest solution is probably to open the db from Windows Scheduled Tasks. I have a few things I do that way. I create an mdb with an autoexec macro that calls a function. That function performs my desired tasks, then closes the db.

Note I had a problem with Windows 7/Access 2007 where I couldn't get an accdb to run from Scheduled Tasks. I had to change it to an mdb.

[jgelpi16]

I appreciate the input. However, if I remember correctly you need your computer on to have the scheduler run. I am looking for a method to run the DB without the reliance on a local machine. I have a server that I could run the scheduler through, but cannot use a local machine.

[pbaldy]

Well, if the server has Access installed, the method should still work. Can your process be done by a batch file, SQL Server, etc?

[jgelpi16]

I am assuming it can. We are using Citrix and I am trying to avoid going through my IT department for the setup.