How to drop a foreign key in Access ( I don't know the name of the relationship)

  • Thread starter Thread starter Audrey
  • Start date Start date
A

Audrey

I have a relationship created in Access 97. I did a little
programming and got the relationship name from the relations
collection - EmployeeOrder. But when I tried to use a sql statement:

Alter Table Order Drop Constraint EmployeeOrder

I got a error saying the relation - EmployeeOrder not exist. ( I
checked and I did not have any spelling error). I ran the programming
again, and I got the relation name of
{974D67D2-FBBD-493B-94D8-6B4069CFA688}

Can you explain why I got the GUID type name. I tried to use the GUID
type name in my sql statement, it did not work either.
 
Back
Top