Backing Up Tables

[Dryseals]

I learned some thing new today, if you make a copy of a linked table, it is still a link. And in the process I wiped out some good info. IT people are restoring yesterdays back up, but I want to build something that will automatically back up tables for me.

I have a db that is split into three sections because of the table sizes. The users use one db for all the forms and such. The other two dbs have all the different tables linked to the first. Split this way for access rights. All in all there are about 40 tables between the two. One table is above all the most important and I would like to back it up at different intervals during the day and keep a few succesive copies in case of another oops.

There is probably 100 ways to do it, but what is the best way back up individual tables? I do not want to back up the whole db because of the size of the tables, just one table is all I need.

Thanks in advance

 

[VBslammer]

[tt]DoCmd.RunSQL "SELECT * INTO tblCurrentBackup FROM tblLinked;"[/tt]

VBSlammer

"You just have to know which screws to turn." - Professor Bob

 

[Dryseals]

Thanks VBSlammer, sometimes the simplest things are right in front of you.