Hi Everyone
I need some help from experts here.
I have an MS Access frontend linked to Sql server backend.
There is no relational integrity defined.
There is an Auto increment field for AutoID in the table.
So the issue is that sometimes some records are getting deleted.
and when i look in the table i can see that some autoid missing in sequence.
i have looked through the code and can not find anywhere a code that would delete from the table.
i also looked at any delete queries and any macros, but there is none to delete data from table.
so what could be the cause of deletion? is there a way i can track how its deleting records.
have i missed something that would cause the delete?
Thanks for the help!
I need some help from experts here.
I have an MS Access frontend linked to Sql server backend.
There is no relational integrity defined.
There is an Auto increment field for AutoID in the table.
So the issue is that sometimes some records are getting deleted.
and when i look in the table i can see that some autoid missing in sequence.
i have looked through the code and can not find anywhere a code that would delete from the table.
i also looked at any delete queries and any macros, but there is none to delete data from table.
so what could be the cause of deletion? is there a way i can track how its deleting records.
have i missed something that would cause the delete?
Thanks for the help!