Database corruption

  • Thread starter Thread starter Ramesh
  • Start date Start date
R

Ramesh

Hi,

My XP database with around 35000 records, 7MB size, keeps getting corrupted
for no apparent reason. Happened 3 times in the last two weeks.

On opening, it says Needs to be repaired or isnt a database file. No change
on repairing the file.

What could be causing this to happen? The same file is being accessed by
others on network, where some systems used Access 2000.

Thanks
Ramesh
 
Ramesh said:
My XP database with around 35000 records, 7MB size, keeps getting corrupted
for no apparent reason. Happened 3 times in the last two weeks.

On opening, it says Needs to be repaired or isnt a database file. No change
on repairing the file.

What could be causing this to happen? The same file is being accessed by
others on network, where some systems used Access 2000.
Click to expand...

Chances are either you need to split the MDB or you need to set the
OpLocks settings. There could be many other causes though.

For more information on corruption including possible causes,
determining the offending PC, retrieving your data, links, official MS
KB articles and a list of vendors who state they can fix corruption
see the Microsoft Access Corruption FAQ at
http://www.granite.ab.ca/access/corruptmdbs.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 
Back
Top