Setting up a task to run automatically on a schedule

[frank.moore]

I would like to save the contents of one table to a Comma Separated
Values (.CSV) file every Saturday at 4 AM. I would like to know if
Access supports this kind of functionality or if I'm going to have to
write a .NET app that will do this.

Thanks.

Frank

 

[roadie.girl]

you can get around writing a .net app and do it all through access ..
or you can write a .net app ...

so in the vba part of access, write a module to save your table as the
file. you can have the function run at the opening of your access
database. after the script runs, have the database close. everything
you will need to do this is in the msdn library.

then just set up your computer scheduler (start / programs /
accessories / system tools / scheduler)

 

[Guest]

Hi,
set up a macro which does this or a macro which calls a module which does
this. Make sure the last action of the macro is to shut down the db.
Then call this macro with the windows scheduler at whatever time you want.
Check this for more:
http://support.microsoft.com/?kbid=230575
HTH
Good luck

 

[Ron Hinds]

I've solved a similar problem by using the Windows Task Scheduler to start
my Access app with a command-line switch (/cmd auto). Then, in the Open
event of my main form, I check for the "auto" switch like so:

If Command = "auto" Then
....
End If

At this point I set a global variable of type Boolean to True and then run
the code. In the code to be run, I check the global each time I might be
showing a user prompt, etc. and skip the prompt if it is True. After the
code is run, I exit the Access application. It works like a champ so far (>
6 months) at nearly 500 installations in the field!

 

[frank.moore]

Thanks everyone. I'll give that a shot.