Records beginning with "Aa" through "Al" are disappearing

[creolejazz]

Hi. I've got an Access 2007 table with about 2,000 records sorted by Last Name. A form is used to input the records. A couple of days ago I noticed that all the records with last name beginning with Aa through Al (Aaron, Abernathy, etc.) are missing. Last name "Amos" is the first one in the list. I re-entered them. The next day, they're gone again. I have no filters on, I've sorted them, they appear to be completely gone. Every day.

Is there something that would cause this quirk that causes only the first 10-12 records in the alphabetized list to disappear? Ideas appreciated. Thanks.

 

[SOS]

First thing up - Go to your form and then view it in DESIGN view. Go to the FILTER property on the properties dialog and look to see if there is something in it. If so, delete it and then save the form. You might be the victim of a persistent filter.

 

[creolejazz]

I actually have two forms that may be used to enter data into this table. I checked both of them and neither have anything in the filter property.

 

[SOS]

Have you looked into the table directly to see if they are still there?

 

[creolejazz]

Yes, in fact that is where I noticed that they were gone.

 

[SOS]

Can you post a copy of the database?

 

[gemma-the-husky]

1. are you sure you arent connecting to different backend databases?

2. are you possibly running some auto-tidying up function that might be deleting these records for some "orphan" reason?

 

[Atomic Shrimp]

Does your database contain any delete queries at all?