Access 2007 Corruption

[Dan B]

We recently upgrade our application to Access 2007 from Access 97. We are now
getting corruptions about once a month were data just seems to disapear. A
single user will be aon a form and tabing from field to field and the fileds
will all of a sudden display #Deleted Or #Error and the record is missing.
Any ideas on why or how this may occur?

 

[Jerry Whittle]

Tony Toews has an excellent web page on database corruption.
http://www.granite.ab.ca/access/corruptmdbs.htm

Allen Brown also has excellent info on corruption.
http://allenbrowne.com/ser-47.html

I have a white paper in a Word document named Fix Corrupt Access Database
towards the bottom this page:
http://www.rogersaccesslibrary.com/OtherLibraries.asp

 

[Dan B]

We use Tony and Allens web sites alot. Fixing corrupt databases is not an
issue. Stopping the corruption in the first place is. We do no that Turning
Oplocks off on the widows servers and client machine reduces the corruptions
tremendiosly. Are there any other wasys to stop slow down the corruption,
especial;y it seems with Access 2007.