# 3063 Repairing a Table that Contains Foreign Keys that Refer to the Same Table Can Cause Lock Error

---

In my contacts table, I have a "ctCompanyKey" whose purpose is to refer back to another record in the same table as the company that is assigned to the contact. This is managed with a foreign key constraint as shown below.

When I run a repair on this table (using my own code or in the database manager), it returns an "Error #300, Cannot lock the table Contacts for shared access".

I think I have the cause isolated to the foreign key as shown below. I've also attached the entire definition of my database stuff in case you need it.