[AccessD] Can't Delete a Bad Autonumber Key:

Ron Moore rmoore at comtechpst.com
Mon Mar 22 09:38:16 CST 2004


We have a A2K Repairs DB where an autonumber key is generated via code
from our Customer Service DB.  The Repairs DB has a bad key (212736)
which cannot be deleted (last good autonumber key is 919).  Error
message reads, 'The search key was not found in any record'.  Cascading
Delete was turned off and we still get the error.  The updates &/or
creations are no longer taking place.  

At a loss,
Ron Moore
Sr. Database Administrator
Comtech PST Corp.
Melville, NY
www.comtechpst.com






More information about the AccessD mailing list