Missing and Corrupt Data

B

Berni Brindle

I have an Access 2000 database for our payroll dept. Over the past few months
the database has been deteriating. We have a problem now where records have
started to dissapear from the database and duplicate records are appearing on
the printouts. I have tried detect and repair, but this does not solve the
problem. I have checked for duplicate programming entries and this is not the
problem. Anybody any suggestions?
 
A

Allen Browne

1. Uncheck the Name AutoCorrect check boxes under:
Tools | Options | General
Explanation of why:
http://members.iinet.net.au/~allenbrowne/bug-03.html

2. Compact the database:
Tools | Database Utilities | Compact/repair

3. Get Access to rebuild your database, by following the steps for the first
symptom in this article:
Recovering from Corruption
at:
http://members.iinet.net.au/~allenbrowne/ser-47.html

That article also contains a link to one explaining how to avoid corruption.
Once you have the database rebuilt, that should really help to prevent the
problem recurring.

Particularly, if you are getting duplicated autonumbers, you really need to
get the service packs for both Office 2000, and also for JET 4. Both are
available in the Downloads section under support.microsoft.com. Once you
have the service packs, this article will help you sort out the problem with
the duplicated autonumbers:
Fixing AutoNumbers when Access assigns negatives or duplicates
at:
http://members.iinet.net.au/~allenbrowne/ser-40.html
 
T

Tony Toews

Berni Brindle said:
I have an Access 2000 database for our payroll dept. Over the past few months
the database has been deteriating. We have a problem now where records have
started to dissapear from the database and duplicate records are appearing on
the printouts
Click to expand...

I'm wondering if the problem is due to queries with the improper type
of joins and/or duplicate data in some of the tables so things aren't
appearing on the reports, etc, etc.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 
Top