Can't delete column because of relationship that doesn't exist

mitchem1

Registered User.
Local time
Today, 01:03
Joined
Feb 21, 2002
Messages
153
Access 2007
I am trying to change the field size of a column (or delete the column all together) and Access won't let me because it says the column is involved in a relationship with another table -- I must first remove the relationship. I have removed every relationship in the entire database but still get the error. Is the table corrupt? I tried running Office diagnostics but no luck. Is there a repair feature?

Thanks in advance
 
Hum... Have you tried exporting the table to a new db?
 
I hadn't tried that but just did and that got rid of the error. Thanks Ken!
 
You're welcome - I get lucky from time to time - :p
 

Users who are viewing this thread

Back
Top Bottom