Subform Font Changed By User

[Keith]

One of my user's just demonstrated something about Access subforms that is
quite scary. Apparently, any user can change the font, color etc. in a
subform. This change then changes the database design...even though the user
didn't know they were changing the database design. Come to think of it,
column widths in datasheet view can also be changed without entering (and
saving in) design view. Is there any way of disallowing this sort of thing.
It seems like a pretty big desing flaw on the part of Microsoft.

Thanks in advance,

Keith

 

[Mark A. Sam]

Keith,

Any .mdb (.accdb) file can be changed by the current user. To stop this
create a .mde (.accde)database for the users. That is the preferrable
method. If you do let the user use a .mdb version, let it be a copy and not
the development version. Also be aware that a user can copy a .mdb and use
it elsewhere. Even with linked tables, if the table structure isn't
complicated, they can recreate them or even steal the backend database. A
..mde isn't as useful as a .mdb and a .mde can be programmed to not run under
programmed conditions.

God Bless,

Mark A. Sam