Records automactically deleting on a table.

[realfanof48]

I have a small database that deleting old records on its own when we enter
new ones. Since I am not an expert I was wondering if there was some type of
max record lock on a table that would be causing this or something else.
Please help me as I have had to re-enter the data a couple of times.

 

[Roger Carlson]

This is not typical behavior and there is no such setting that will cause
this. My experience has been that it is operator error. Someone is
over-writing an existing record when they think they are entering a new one.
How are you entering records? In the table directly? In a form?

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[BOGDAN]

czesc

 

[Danny J. Lesandrini]

Why do you think the records are being deleted? Are you viewing
them directly from the table, or a form-query?

 

[realfanof48]

I think it something by date or maximum records alotted. I find this on the
table and on any form-query attached to the table. Other tables in the
database are not doing it but I can not figure out the difference.

 

[BruceM]

There is no maximum number of records. Maximum database size is 2GB in
Access 2003. If it is about the date you have code that deletes records.
Does this happen with all operators all the time? Is there any code in the
form?