In code, copy and paste a table in another database

  • Thread starter Thread starter David
  • Start date Start date
D

David

I have an mde that uses an associated mdb for external
tables that are replicated. Since they are replicated, I
cannot make any changes to the structure of the table. I
no longer need the replication, but since this is a
distributed product with client specific records in the
external tables, I cannot make changes here and
redistribute the database without losing all the data the
clients have in their database without some kind of copy
routine. The simplest solution would be, from my mde, copy
the replicated table, paste it back with a different name,
rename the old table, rename the new table to the old
name, and then delete the old table. Is there a way that
anyone knows of that I can do in code to effect this.
 
If your table is participating in any relationships, you'll need to destroy
all of those relationships before you can make the changes you describe.
Then recreate the relationships afterwards - your new data permitting!
 
Back
Top