Backing up tables

[rkrause]

I have taken over a database from a previous employee and he has a section built in to back up tables, but its not functional yet. Basically all it is, is a button with no code behind it. I would like to implement that, could someone give me some advice and some code on how to back up tables?

thanks

 

[HiTechCoach]

I have taken over a database from a previous employee and he has a section built in to back up tables, but its not functional yet. Basically all it is, is a button with no code behind it. I would like to implement that, could someone give me some advice and some code on how to back up tables?

thanks

Normally, you back up a database, not a table.

I searched and found this:
Backup database

If this is not what yu need, would you plaase explain in detail what you are trying to do.

 

[pbaldy]

You could use TransferDatabase to copy the tables to another database, or use append queries to copy specific records. I haven't needed TransferDatabase, but I would suspect you'd have to make sure no users were in the tables to avoid locking issues.