Records disappearing

[netcert]

We have a db that over the last 2 years has been losing records. They are just disappearing. There seems to be no ryhme or reason to it. Is there anything within access that can be done to prevent data from just disappearing? I asked the user who all had access to the db and it was just her. I suggested setting up rights to it so that she is the only one who can make changes to it and she told me that she thinks thats how it was setup to begin with.

So, again, is there anything within access that can be done to prevent data from just disappearing?

 

[PaulBricker]

First, make sure that any fields you have that are joined fields with other tables have the Required property set to Yes. In one of the Db's we use, I was losing records for no apparent reason. Our Main Table had joins to three other tables. When I set the Required property for these joined fields in my Main Table to Yes, we stopped losing records.

Paul

 

[cmmrfrds]

Does the application have a relationship set up and are you using cascading deletes on that table?

 

[netcert]

there are no relationships set up. excuse my ignorance but what r cascading tables? never heard of them.

 

[PaulBricker]

Cascading deletes. If you delete records in one table, related records in other tables are deleted at the same time but if you don't have any relationships set up on your table then that wouldn't be a factor. Are you using an AutoNumber in the table for your Primary Key?

Paul

 

[JonFer]

You can have the user enter data using a form that does not allow deletes but if they can get to the table directly, it is not a sure prevention.

If they are already using a form, check the form module for anything that could cause a delete. Same for any macros called by the form.

Are the tables linked? If so, check the source database for relationships.