Copy tables from BE to another DB 1

[annsolomon]

I used the TransferDatabase method to copy several tables to another database thinking I was backing up data in case my users messed up and I had to recover data. I put the code in my front end. It turns out that, apparently, I only copied the links to the tables.

How can I, from my front end db, copy tables from the back end to a third database? Everything I've found so far only copies from the Current database. Ann

 

[PWise]

in your front end create a link to your backup database and us a append query

 

[annsolomon]

Thanks pwise. Not sure how it happened that I never notice the option to append or update a table in another database. (Actually, I ended up using an update.) Have a star on me! Ann