Removing a field

[C Tate]

I have to remove a field from one of the tables in my database. Access is
telling me 'You can't delete the field. It is part of one or more
relationships. Delete the relationships from the relationships window first.'

Now, I deleted all the relationships leading to the table whose field I wish
to delete. However, Access keeps repeating the same message.

What can I do to get rid of this field?

 

[Allen Browne]

Try listing the relationships programmatically, to see if there is still a
hidden one:

Public Function ShowRel()
Dim db As DAO.Database
Dim rel As DAO.Relation
Dim fld As DAO.Field

Set db = CurrentDb()
For Each rel In db.Relations
Debug.Print rel.Name, rel.Table, rel.ForeignTable,
RelationAttributes(rel.Attributes)
For Each fld In rel.Fields
Debug.Print , fld.Name, fld.ForeignName
Next
Next

Set fld = Nothing
Set rel = Nothing
Set db = Nothing
End Function

 

[KARL DEWEY]

In the Relationalship window click on Show All to see if there are more.
Check your queries also.