[AccessD] Missing records

We had missing recordsin an app here a while back.  We never really figured out what happened but one possibility we found was the user(s) may have pressed Ctrl + A to select all data in a record (displayed on a form).  Well Ctrl + A really selects all records in a form's recordset (A97 at least).  If they pressed Delete and ingnored the warning goodbye data.  We've since disabled that key combination.

Good luck,

Jim DeMarco

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of John Clark
Sent: Friday, February 03, 2006 9:51 AM
To: accessd at databaseadvisors.com
Subject: [AccessD] Missing records


We got a call from a department that has a small Access 2K db.
"Something" has happened, and they are missing about a quarter of their
records. This was being investigated by a technician and I was just
asked the following question:

If a PC is "hard-booted" can an Access DB lose records w/out showing
signs of corruption (i.e. the db still runs)?"

I really don't know the answer to this question. I have had nearly no
experience w/db corruption, since starting with Access 5 years ago. I
used to use FoxPro...there are still some old FoxPro 2.6 (DOS) dbs
hanging around actually...and corruption was a huge problem w/them.

Anyone got any tips on this?

Thanks!

John W Clark
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com


 



***********************************************************************************
"This electronic message is intended to be for the use only of the named recipient, and may contain information from Hudson Health Plan (HHP) that is confidential or privileged.  If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution or use of the contents of this message is strictly prohibited.  If you have received this message in error or are not the named recipient, please notify us immediately, either by contacting the sender at the electronic mail address noted above or calling HHP at (914) 631-1611. If you are not the intended recipient, please do not forward this email to anyone, and delete and destroy all copies of this message.  Thank You".
***********************************************************************************