Form Properties changing unexpectedly

[jpr]

I have a small multi-user (non-split) Access 2000 database in which a form
and it's sub-form properties will change. Specifically, "Allow Edits",
"Allow Deletions", and "Allow Additions" are changed from True to False.
The database may work fine for a week or so. Then, without warning, users
cannot add or edit data and the form's properties have been changed. This
has happened three times so far; once in the main form and twice in it's
subform. Could this be possible corruption? I have compacted and repaired
each time after setting the form properties back to True. Help!

 

[Klatuu]

This could be caused by a number of things.
Your biggest problem is "multi-user (non-split)". You are begging for
corruption. Your performance is suffering. And, anything one user does will
affect all other users. If by chance a user changes any properties and the
form is saved, it will create this. It may be the user is not even aware
they are making changes. It may be something in your code causing the
changes.

Your first task should be to split your database and give each user a copy
of the front end, then see when and where this happens.

 

[Dirk Goldgar]

I have a small multi-user (non-split) Access 2000 database in which a
form and it's sub-form properties will change. Specifically, "Allow
Edits", "Allow Deletions", and "Allow Additions" are changed from
True to False. The database may work fine for a week or so. Then,
without warning, users cannot add or edit data and the form's
properties have been changed. This has happened three times so far;
once in the main form and twice in it's subform. Could this be
possible corruption? I have compacted and repaired each time after
setting the form properties back to True. Help!

I've had this happen when my code was toggling those properties, for
reasons particular to the application, and the user clicked the Save
button on the toolbar (thinking it would save the record).