Corrupt Record

[Doug]

I am having a frequent problem occur. We use a database
to write our Ambulance Reports on and once a month or so
a record will contain all these foreign looking
characters, I have to transfer the data to blank
database, skipping the bad record because I cannot delete
the bad one. We are using Access 2000. I was wondering
what causes this and how to prevent it. I have searched
this news group and microsoft support and been unable to
find anything on it. Please help!

 

[Arvin Meyer]

Corrupt records are caused most often in tables with Memo fields, since the
Memo data is stored on a different page (disk address). 99+% of all
corruptions are caused by a disconnection during the write process.
Sometimes the computer will hang and the user must shut it off. Sometimes
users just forget and shut down by powering down without closing. Sometimes
there is a power outtage on an unattended machine that goes beyond the
battery backup. And lastly, there is often a bad NIC card or video card that
can cause the problem.

Most of the corruptions are caused by users or bad NICs.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[Doug]

Thank you for your help. There is a memo field and the
data base is on a network. I beleived it was because of
people shutting down improperly but was unsure.