deleting/renaming tables

[dumdum2]

I am trying to set up a macro that will copy several tables from one database to another. The process needs to REPLACE the tables in the database that I am copying to. If I try to export to the other database, I can't seem to get around the message that 'the table is participating in one or more relationships. Delete the relationship first.'

What's the easiest way to update another database with the current database's tables?

Thanks!

 

[lespaul]

delete all the records from the target database and then append the records.


Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for anyone working with databases: The Fundamentals of Relational Database Design