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 gkittelson 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
Jul 25, 2006
114
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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top