Creating Make Tables with a scheduler

C

ChuckW

Hi,

I am going to be running MS Access on a Windows 2003
server and every night, I want to create certain tables
based on some queries. I want to have these scheduled
using Microsoft Windows Scheduler. For instance, I want
to create a make table called Alltransactions2004. Every
night I want to run a query that replaces this table.
What is the best way to do this?

Thanks,

Chuck
 
Top