Disappearing Acts

J

Julius

Can anyone tell me if Access deletes records for no reason, I mean today a
record is here and tommorro its gone. I am a Quality Specialist/Database
Admin I recently completed a database for our Call Center that allows us to
monitor our customer service representatives and score their calls. I have a
table called New Monitor table that holds the monitor information. Nothing
fancy is setup to that table. I have this one Quality Staff who keeps
telling me that her records are deleting. It does not happen all the time
and it only happens to her. Is it something she is doing or Access. Lastly
is it anyway to track when a record is deleted intentionally or accidently.
I don't have User ID and Logons in place can I track without this. Any help
would be greatly appreciated. Oh and please explain it to me in layman terms.
 
R

Roger Carlson

She may be over-writing an existing record when she thinks she is entering a
new one. I've had that happen a lot with new users. My solution is to
provide a form that can ONLY enter new records. You have to go to a
different form to edit them. Other solutions are possible.

On my website (www.rogersaccesslibrary.com), is a small Access database
sample called "AuditTrail.mdb" which illustrates keep track of who did what.
It uses network logins (as opposed to Access security), so if you have
those, it should work.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L
 
P

Pat Hartman

another possibility is that there is an error in your form and on occasion,
it creates orphan records. When you next open the form, the orphan records
will appear to have disappeared but are in fact still in the "child" table.
They just have no value in their foreign key to the "parent" table - hence
the term "orphans".
 
Top