Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

deleting/renaming tables

Status
Not open for further replies.

dumdum2

Programmer
Joined
Mar 18, 2000
Messages
98
Location
GB
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!
 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top