Remove Linkages from tables

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

Guest

Is there a way to remove all the linkages from a database. I want to be able
to delete the table linkages all at once for a database, not one at a time
using the delete button.

Thanks,

Rob
 
RobUCSD said:
Is there a way to remove all the linkages from a database. I want to be able
to delete the table linkages all at once for a database, not one at a time
using the delete button.


What do you mean by "linkages"? If it's the links to a
backend database, then you can just delete the front end
TableDefs. If you are talking about removing Relationships
between tables, then just do that.

You can loop through either collection from the last to the
first member using the Remove method. BUT, without those
relationships, you expose your data to all kinds of
inconsistencies.

Before I go shooting in the dark, a few clues abot what you
are trying to acompish would save us both some wasted
effort.
 
Back
Top