Subform Properties Changing Unexpectedly

[jpr]

I have a database application where a subform’s properties are being changed
unexpectedly. The properties being changed are AllowFilters, AllowEdits,
AllowDeletions, AllowAdditions. These four properties are being changed from
Yes to No. The database will work fine for months, then one day, I cannot
edit data in this subform. When I view the form’s properties (listed above),
they are set to “Noâ€. I can reset them to “Yes†and the database is fine for
a while but eventually, they will be set back to No. What could cause this?

 

[Stefan Hoffmann]

hi,

I have a database application where a subform’s properties are being changed
unexpectedly. The properties being changed are AllowFilters, AllowEdits,
AllowDeletions, AllowAdditions. These four properties are being changed from
Yes to No. The database will work fine for months, then one day, I cannot
edit data in this subform. When I view the form’s properties (listed above),
they are set to “Noâ€. I can reset them to “Yes†and the database is fine for
a while but eventually, they will be set back to No. What could cause this?

Someone changed them. Use a .mde to prevent users from changing forms.


mfG
--> stefan <--

 

[jpr]

hi,

Someone changed them. Use a .mde to prevent users from changing forms.
mfG
--> stefan <--

It's not likely that someone changed them. It's a secure database and the
subform is buried inside another subform. I like your idea of an .mde
I was wondering if it could be caused by corruption. I've tried compiling
and decompiling but it still keeps happening.

 

[Stefan Hoffmann]

hi,

It's not likely that someone changed them. It's a secure database and the
subform is buried inside another subform. I like your idea of an .mde
I was wondering if it could be caused by corruption. I've tried compiling
and decompiling but it still keeps happening.

Don't think it is corruption. Corruption as far as i had dealt with, had
caused far more serious problems.