Relationships.. how to lose them and create them again (SQL)

[nowanda]

Howdy!

In MS Access 2000 I have 5 tables I need to drop because a collegue is sending me those 5 tables with different values. I'm of course able to drop tables as long as the relationship is not there.. but is there a way I can script the deletion of the relationships and drop the tables.

Later on I'd like to add those new tables and implement the new relationships..

How are relationships dealt with via SQL?

Nowanda

 

[dk]

Hi,

Rather than reinvent the wheel, I will just point you to a fairly easy to understand MS article. If you get stuck, please post back here and we'll see what we can do.

http://support.microsoft.com/support/kb/articles/q116/1/45.asp