G gearykl Jan 5, 2004 #1 Is there a way to have Access automatically make a copy of a table nightly? Thanks for your help.
R Ray Gibson Jan 5, 2004 #2 I'm thinking, yeah this is simple. Create a macro that runs a make table query. The hard part, I've never scheduled a macro.
I'm thinking, yeah this is simple. Create a macro that runs a make table query. The hard part, I've never scheduled a macro.
I Immanuel Sibero Jan 5, 2004 #3 Hi To add to the previous post, Windows' own Task Scheduler can be used to run Access every night. Access will not be able to schedule itself unless it's running all the time. HTH, Immanuel Sibero
Hi To add to the previous post, Windows' own Task Scheduler can be used to run Access every night. Access will not be able to schedule itself unless it's running all the time. HTH, Immanuel Sibero
T Tim Ferguson Jan 6, 2004 #4 Is there a way to have Access automatically make a copy of a table nightly? Click to expand... Use the Task Scheduler to run a vbs script. Use the Task Scheduler to run Access with a /m startup switch (see help files) Leave Access running and use a Form with an active Timer event Train the overnight cleaning staff (My vote always goes to the first one) HTH Tim F
Is there a way to have Access automatically make a copy of a table nightly? Click to expand... Use the Task Scheduler to run a vbs script. Use the Task Scheduler to run Access with a /m startup switch (see help files) Leave Access running and use a Form with an active Timer event Train the overnight cleaning staff (My vote always goes to the first one) HTH Tim F
