> Hi all,
>
> I came across this database this morning. It belongs to a client
> of ours who
> was reporting some errors when using our software. On inspection of the
> database the table in question seems to have duplicates in the primary key
> column.
>
> Has anyone ever seen this before, or do they know of how it could
> occur? The
> table does not have any foreign keys and the database is generally only
> accessed by the one connection.
>
> I have made a copy of the database available, however all of the
> triggers /
> stored procedures / views and non-related tables have been
> removed. The only
> table in the database is titled MBUSERCOMPANY, if you look at the
> row where
> COMPANYNAME is 'Seaside Home Loans' you will see that there are
> two entries
> both with the same key.
>
> The database zipped down to ~3Mb, I tried doing a backup/restore on it but
> the restore failed with an integrity check error (the duplicate PK).
>
> Here's the database:
> http://www.transactive.com.au/dup_pk.zip
>
> Any insight into this would be great.
>
> Cheers,
>
> Ryan Thomas
> TransActive Systems

it was possible on FB1.03 I think to run with deactivated PK indexes. Have
you checked this?
Alan