Loosing Records

  • Thread starter Thread starter Steve L.
  • Start date Start date
S

Steve L.

I appear to be loosing records from an Access 2000
database. The db is shared by 6 users. All os's are w2k
pro, sp3 or better, office updates are reasonably current.
Random records seem to disappear from the main table at
some point after entry (data entry is through a form).
Most records can be found if I restore the db from a
backup tape, although sometimes there are gaps. The db is
linked to another from which it draws customer and project
info during the main processing query. I fear I may have a
malicious user deleting these records but can't prove it
and I hesitate to believe it, but this is just too wierd.
Physical access to the workstations is not completely
restricted. Thanks in advance for any suggestions or
advice.
 
I appear to be loosing records from an Access 2000
database. The db is shared by 6 users. All os's are w2k
pro, sp3 or better, office updates are reasonably current.
Random records seem to disappear from the main table at
some point after entry (data entry is through a form).
Most records can be found if I restore the db from a
backup tape, although sometimes there are gaps. The db is
linked to another from which it draws customer and project
info during the main processing query. I fear I may have a
malicious user deleting these records but can't prove it
and I hesitate to believe it, but this is just too wierd.
Physical access to the workstations is not completely
restricted. Thanks in advance for any suggestions or
advice.
Click to expand...

You may need to search for errant code or query activity in the application
before you conclude that you have a malicious user. Then again, your
"malicious" user may just be a naive user.

:-)
 
I appear to be loosing records from an Access 2000
database. The db is shared by 6 users. All os's are w2k
pro, sp3 or better, office updates are reasonably current.
Random records seem to disappear from the main table at
some point after entry (data entry is through a form).
Most records can be found if I restore the db from a
backup tape, although sometimes there are gaps. The db is
linked to another from which it draws customer and project
info during the main processing query. I fear I may have a
malicious user deleting these records but can't prove it
and I hesitate to believe it, but this is just too wierd.
Physical access to the workstations is not completely
restricted. Thanks in advance for any suggestions or
advice.
Click to expand...

You could implement Access security and limit record deletion to
authorized users; if users can only view data in Forms, you could also
put code in the Form's BeforeDeleteConfirm event to either post a
record of who is deleting what, or block the deletion altogether.

As suggested - "never blame on malice what can be explained by
ignorance". Some people new to databases may feel that it's perfectly
appropriate to delete records from a query when they don't want to see
those records appear in a report, not realizing that doing so deletes
the record permanently from the master table!
 
Back
Top