Filtering Records

[nathangoldhill]

I have a problem that keeps re-occuring on my databases all different. When a user trys to filter for data the Access comes up with record is deleted. Although the data is their.

I can solve the problem each time by cutting the tables out and pasting them in a old restored database. But this is becomming v tiresome and a regular occurence.

I am not sure whether it is user error which keeps causing this to happen on different databases or just a software glitch.

Any help would be much appreciated asap.

Nathan

 

[Chris RR]

Does a compact & repair on the database fix it?

 

[nathangoldhill]

Yeah a compact and repair does fix it! But what causes this in the first place?