Icon View Incident Report

Serious Serious
Reported By: Dale Derix
Reported On: 8/27/2009
For: Version 2.02 Build 15
# 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.

Resolution Resolution
Fixed Problem on 8/29/2009 in version 2.03 build 1

Products Affected Products Affected
ElevateDB Additional Software and Utilities
ElevateDB DAC Client-Server
ElevateDB DAC Client-Server with Source
ElevateDB DAC Standard
ElevateDB DAC Standard with Source
ElevateDB DAC Trial
ElevateDB LCL Standard with Source
ElevateDB VCL Client-Server
ElevateDB VCL Client-Server with Source
ElevateDB VCL Standard
ElevateDB VCL Standard with Source
ElevateDB VCL Trial