Duplicating and Self deleting Autonumber ID

[cabrio]

I have a database where almost daily customers get deleted seemingly automatically, and Autonumber IDs get duplicated. This is all in only one table. Autonumber field is CustomerID(Indexed - Yes (No Duplicates))

The weird thing is, is that it is not related to new customers, these are customers that are halfway through the database. The customers that get deleted may or may not have related records. If I try to delete a customer manually, I cannot because there are related rcords. So this is a bit of a mystery. Records that are not supposed to be able to be deleted are, and CustomerID's that are not supposed to be duplicated are.

 

[r937]

who has access to the database? go talk to them and ask to see what sort of queries they are running

 

[cabrio]

no one but my self has access to the tables, about twenty users have access to the front end of the database(forms and etc.)

 

[r937]

well, then it's gotta be one of the "forms etc" that's doing something wrong

databases do not lose records by themselves, it is always a result of some user action

sorry i couldn't help any further, but you haven't given us a lot to go on

rudy

 

[cabrio]

I guess what I should be asking to clarify things, is what kind of code or query can both override the autonumber with no duplicates and delete customers when the relationship has refferential integrity.

I cannot delete customers in the tables that have related information in another table.