> I have a membership database in Access
> 2003 that goes back several years.
> Recently, several records are just no longer
> there, they have disappeared. If I search
> for a particular record, the data is not there.
> I am the only one who uses this database.
> Any ideas what might have happened? I can
> reenter the data that I know is missing,
> but there might be more that I haven't identified
> yet. Has this happened to anybody else?
There are many things that can happen, hardware or software, that couldReference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13835
cause data loss. That is why the universal recommendation is for taking
regular backups, on a frequency that will minimize the amount of data
re-entry if you have to restore.
After making your backups, you should use the menu item Tools | Database
Utilities | Compact and Repair.
Before you do anything -- MAKE A COPY because attempts to recover could make
a temporary loss permanent. Be sure and do this BEFORE doing Compact and
1. Are you sure you are searching on the exact contents of the search Field?
2. Remember that data stored in relational tables is, by definition,
unordered, so you may need to use a Query and specify the Fields to be
sorted if you are going to browse through.
3. If there is corruption in the database, you may be able to create a new
empty database, use File | Get External Data, to import the objects, _then_
Compact and Repair.
If worse comes to worse, there are third-party recovery services. One ofReference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13835
which I have heard nothing but good reports is http://www.pksolutions.com
Microsoft Access MVP