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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

unable to delete field - relationship 1

Status
Not open for further replies.

fredka

Technical User
Joined
Jul 25, 2006
Messages
114
Location
US
I am trying to delete a field in one of my tables. I am getting an error that I can't delete because it is part of a relationship - I have deleted all relationships in the backend and front end yet I am still getting this message.

Thanks!!!!

Fred
 
Copy the table using "structure only" and rename it, then edit out the column in design view and do an insert query from the old table (minus the missing field). Delete the old table, then rename the new. Oughta work...

Outside of a dog, a book is man's best friend. Inside of a dog it's too dark to read.
 
thanks!!!!

Fred
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top