Everyday Computing Advanced Computing The Internet At Home Health, Mind & Body Making & Managing Money Sports & Leisure Travel Beyond The Classroom
Certification
Databases
Networking
Programming
Win a Trip to New York City to see Monty Python's SPAMALOT!
Access 2002 For Dummies

Solving the Mystery of the Disappearing Record in Access 2002


Adapted From: Access 2002 For Dummies

"The record was there — right there!" The key word in that sentence is the verb, because it indicates that the record isn't there now. Precisely where the record went is a moot point because only the computer knows, and machines have a code of silence about these details. (It's a subset of the rules that make all the copiers break at the same time.)

icon

Don't panic. Panicky people make strange changes, and you need your wits about you for the next few minutes. You can panic later after the dust settles.

Before doing anything technical with Access 2002 (or hitting the computer with a baseball bat), press Ctrl+Z. That's the Undo command. If the record comes back, you're done. In that case, close the table and go have a panic attack in the break room.

If the Undo command didn't accomplish anything, you're in slightly more trouble. The next best solution is to copy the record from a backup of the database file. This solution works only if you backed up your database at some point. If you have a paper copy of the data, you can always manually re-enter it into the database. If that record was your only copy of the information, then raise your hand, look at the computer, and wave bye-bye, because it's gone now (you have my deepest sympathy).

icon

Please, oh please, keep current backups of your information. You never know when bad things will happen (insert eerie organ music here).

Related Articles
Improving Speech Recognition in Access 2003
Pushing Your Access 2003 Data onto the Web
Taking Your Access 2002 Report to the Design View Tune-Up Shop
Creating a Primary Key in Access 2002
Making Sense of the Database Window in Access 2002
Related Titles
Access 2007 For Dummies
Access 2000 for Windows For Dummies Quick Reference
Access 2002 For Dummies
Access 2002 For Dummies Quick Reference
Access 2003 For Dummies