Access XP randonly deleting records?

M

mertman

I'm having a problem where Access (XP version) randomly deletes records. It
happens when one or more people have a database open.
 
L

Lynn Trapp

Why do you believe Access is deleting the records? Access doesn't
automagically delete records unless there is some kind of corruption. You
said, "It happens when one or more people have a database open." Since it's
not possible for a database to be open by zero people, that would mean
anytime the database is open. Could we please get some more information from
you?
 
V

Van T. Dinh

.... with human helps, perhaps?

I have never seen Access randomly deletes Records.

Either users deleted Records by mistake and denied responsibility or the
incorrect code in the database instructed Access to delete Records ...
 
M

mertman

Two reasons:

1) After my client has reported an instance I look at the table in question
and there are lines that say "record deleted" and there are lines where some
information is blanked out and some has ###### in them;
2) Last week I and one the clients had the database open (we were the only
two), I was looking at her screen while she had a table open and while we
were looking at the table one of the records was deleted (the lines that say
record deleted).

What I said what was "when more than one person has the database open" .

I really suspect some kind of network problem and was hoping others had had
a similar experience so I could track it down. We have a Novell 6.x network.

Any utilities out there for finding corruption in a database?
 
Top