Main Table BackUp

[Russ]

I was wondering if anyone out there has ever used the
system date and time via a form to make a backup of a main
table at 5:30 PM on Friday of every week. Is this possible
outside of a NT Network system backup? This would internal
to Access only. The backup table would get over written
every Friday too, just keeoing it around long enough to
verify data.

If you've done this sort thing before and have sample
code, please, I can use the help! If it's not possible,
then, that's okay too.........

Thanks,

 

[dgoss1]

If the database is up and active all the time then yes it is possible
Probably the easiest way to do this is to duplicate the table you want to backup in another database; set up a linked table in your current db to the backup table you just created; set up a queries that clear the backup table, and one to insert to the linked table from a select off of the main table. you should then be able to set up a macro to execute these querries and execute the macro from a timer that checks the day to determine if it is time to backup
If your are comfortable with coding, then instead of macros, you could do it all through code
If the db is not constantly running, the only way I can think of right off is an external app (like the NT backup) or another 3rd party scheduler.