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?

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
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"Dan B" wrote:

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

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.
--
Dan Byers , MCP
Move-N Software


"Jerry Whittle" wrote:

> 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
> --
> Jerry Whittle, Microsoft Access MVP
> Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.
>
>
> "Dan B" wrote:
>
> > 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?