Access XP randonly deleting records?

[Guest]

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

 

[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?

 

[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 ...

 

[Guest]

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?

 

[Lynn Trapp]

Could be 2 possibilities. (1) The database is corrupted, which would be my
first suspect. (2) A user accesses a record that has been altered or deleted
by another user. Is the database split? Is OpLocks turned off?

Take a look at www.granite.ab.ca/corruptmdbs.htm

 

[Ken Snell [MVP]]

Additionally, check that all Office XP updates and patches have been
applied.

I've seen some weird results when running ACCESS 2002 database on a PC that
is missing the very latest Jet and/or Office XP patches/upgrades, including
overwriting of other records, deletion of records, insertion of records with
erroneous foreign key values, etc.

 

[Lynn Trapp]

Excellent thought, Ken. Thanks for the addition.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm

 

[Guest]

(1) If the database is corrupted, how do I stop it from being corrupted after
I've fixed it?

(2) How do I prevent this from happening?

(3) I'm checking with our Server guys about Oppurtunity Locks.

Although the page you mentioned was not available The granite website was
very informative and had several pieces of information on corrupted dataases.

Thanks for you help.