I've run the ompm scan utility to gather data for department files shares.
Most departments data imported into the SQLExpress database correctly.
However, I have been getting the following message on specific departments:

ERROR: Import operation failed.
The statement has been terminated.
<?xml
version="1.0"?><Error><Record><HResult>0x80004005< /HResult><SQLState>01000
</SQLState><NativeError></NativeError><ErrorState>1</ErrorState><Severity>0</Severity><Source>Microsoft
OLE DB Provider for SQL Server</Source><Description><![CDATA[The statement
has been
terminated.]]></Description></Record><Record><HResult>0x80004005</HResult><SQLState>23000</SQLState><NativeError></NativeError><ErrorState>1</ErrorState><Severity>14</Severity><Source>Microsoft
OLE DB Provider for SQL Server</Source><Description><![CDATA[Violation of
PRIMARY KEY constraint '
PK_AccessReferences'. Cannot insert duplicate key in object
'dbo.AccessReference
s'.]]></Description></Record></Error>

I've one back to verify that no duplicate files exist in the directories and
repeatedly deleted the DB and recreated it.

Is there a way to determine what is causing this error, and how to get
around it? Any suggestions are greatly appreciated.

Thanks

John Clumpner
clumpnerj@schneider.com