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

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Deleting a foreign key relationship in SQL 2
Display Relationship Name so I can drop it 3
dropping a relationship (i.e. constraint?) 7
How to remove relationship? 4
Create a indeterminate relationship in access using sql 2
Windows 10 I would like to know in a batch file how to indentify computer name by using the first 5 of the name and the last 2 of the name then call runcmd 0
How to filter out the same values in the drop-down list of a combo 5
reate relationship as each excel table is imported VBA 1

Top