Any changes in the network? Server? Client stations? Network drivers?
>
>I should also mention that, according to the audit trail, neither record was ever deleted.
>
>I use a Primary Key table that has the last Id value used for each table. The default value of the key fields calls a stored procedure, SP_IDNEXT, which looks up the tablename in my Primary Key table, locks the appropriate row, increments the value, Unlocks the row and then returns the new id.
>
>Also, the tables (and method of assigning IDs) has been in place for years - since VFP3. This has become an issue only in the past several months. I'd guess there are around 150 entries in the Primary Key table (ie. around 150 tables. This is the only table that has this problem.)
>
>Thanks,
>Alan
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer