Create local copy of Linked Table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a database with 20 linked tables. I want to take an image of those
tables once a day and create a copy of tables within another database for
endusers to access. If I do a transferobject macro the resulting table
remains a linked table, not as a stand alone copy.

Thank you in advance for any all input.
 
Instead of trying to copy tables, use queries to handle the data. For each
table, you need a delete query to delete the "old" data from the table in
the other database, and an append query to copy the current data.
 
What about leaving the tables as linked tables but to a different mdb. (This
is assuming that we are talking of a split mdb situation). Have the "local"
FE point to a "local" BE. Then all you have to do is copy the remote BE mdb
file on top of its prior version. Essentially you are cutting out half of the
work and have less bloat.
 
Back
Top