Prevention of form corruption

[lsloan]

Hi!

I have a reoccuring problem with one of my databases where forms will
occasionally become corrupted. Since I have backup copies of my
production databases, it is easy to recover from using the 'standard'
methodology discussed in the various threads that address this issue.
However, I would like to prevent the problem from happening in the
first place.

This has occured to different forms in my database and it strikes
seemingly at random times.

Does anyone have any information on what are possible root cause of
form corruption problems?

Thanks in advance for any advice or direction!

LSloan

[Allen Browne]

Our experience is listed in:
Preventing corruption
at:
http://allenbrowne.com/ser-25.html

Crucial factors include:
- ensuring stability of hardware, power, network, configuration, users;
- applying service packs for JET as well as Access;
- dumping Name AutoCorrect;
- not edit code of an object that is open (i.e. if it is not in design
view);
- including a control on the subform for every field nominated in
LinkChildFields;
- recogising the first signs of corruption, and acting proactively.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"lsloan" <ls**********@yahoo.com> wrote in message
news:c5**************************@posting.google.c om...

I have a reoccuring problem with one of my databases where forms will
occasionally become corrupted. Since I have backup copies of my
production databases, it is easy to recover from using the 'standard'
methodology discussed in the various threads that address this issue.
However, I would like to prevent the problem from happening in the
first place.

This has occured to different forms in my database and it strikes
seemingly at random times.

Does anyone have any information on what are possible root cause of
form corruption problems?

Thanks in advance for any advice or direction!

LSloan

[Larry Linson]

Do you have more than one person logged in to the database (or frontend, if
it is a split database)? That can significantly increase your chances of
corruption of the type you describe, particularly if those users are on
different versions of Access or the same version with different Service
Releases/Packs applied. I've had that reported so many times that it is the
first thing I ask these days.

If you have a multiuser environment, I strongly suggest splitting the
database and giving each user their own copy of the front end (queries,
forms, reports, macros, modules, and any local lookup tables) linked to
tables in the back end (tables, relationships, and data) on a shared folder
(and each user must have full permissions on the shared folder).

But there are other causes of corruption. The very best collection of
information and links on the issue, and on multiuser performance, that I
have seen are at MVP Tony Toews' site,
http://www.granite.ab.ca/accsmstr.htm.

It probably wouldn't have made a great deal of difference in my answer here,
because corruption of front-ends and monolithic databases is not a clear-cut
thing. But if you are having a specific problem, it sometimes is helpful if
you say which Windows O/S you are using, which version of Access, what
Service Release / Service Pack level has been applied, what the environment
is (single-user, multiuser, Windows domain with backend on a server, or peer
to peer with backend on a share, etc.).

Larry Linson
Microsoft Access MVP

"lsloan" <ls**********@yahoo.com> wrote in message
news:c5**************************@posting.google.c om...

Hi!

I have a reoccuring problem with one of my databases where forms will
occasionally become corrupted. Since I have backup copies of my
production databases, it is easy to recover from using the 'standard'
methodology discussed in the various threads that address this issue.
However, I would like to prevent the problem from happening in the
first place.

This has occured to different forms in my database and it strikes
seemingly at random times.

Does anyone have any information on what are possible root cause of
form corruption problems?

Thanks in advance for any advice or direction!

LSloan