How to protect form design from user changes

[Andrea]

I have a form on a remote computer that students use to scan in their ID
numbers to reserve study spots in our library. The little dears keep
changing the font color to white so that scans don't show upon scanning.

How do I protect the form from design/property changes and still allow data
to be entered? Ideally, I would like to set the protections on the server so
that students are blocked on the remote from making changes.

Thanks very much!

 

[Carl Rapson]

I have a form on a remote computer that students use to scan in their ID
numbers to reserve study spots in our library. The little dears keep
changing the font color to white so that scans don't show upon scanning.

How do I protect the form from design/property changes and still allow
data
to be entered? Ideally, I would like to set the protections on the server
so
that students are blocked on the remote from making changes.

Thanks very much!

Convert the .MDB into a .MDE (Tools > Database Utilities > Make MDE
File...). No design changes can be made in an .MDE.

Carl Rapson

 

[Rick Brandt]

Convert the .MDB into a .MDE (Tools > Database Utilities > Make MDE
File...). No design changes can be made in an .MDE.

Important bit of pedantry. Use your MDB as the source to create a NEW file
that is an MDE. It is not really a conversion. The important bit is that
you need to keep your copy of the original MDB because that is the only one
you can use to make future design changes to.

 

[Andrea]

OK, thanks very much guys. Will read up on creating an MDE file from the MDB
file.

 

[Jeff Conrad [MSFT]]

You'll find a very good read on this subject here:

http://www.utteraccess.com/forums/showflat.php?Cat=&Board=53&Number=1419510

--
Jeff Conrad - Access Junkie - MVP Alumni
SDET - XAS Services - Microsoft Corporation

Co-author - Microsoft Office Access 2007 Inside Out
Presenter - Microsoft Access 2007 Essentials
http://www.accessmvp.com/JConrad/accessjunkie.html
Access 2007 Info: http://www.AccessJunkie.com

 

[Klatuu]

In addition to the sound advice you have received, it may be useful to slap
the snot out of the "little dears"
--
Dave Hargis, Microsoft Access MVP

OK, thanks very much guys. Will read up on creating an MDE file from the MDB
file.
--
Andrea

news:[email protected]... [snip]
How do I protect the form from design/property changes and still
allow data to be entered? Ideally, I would like to set the protections
on the
server so that students are blocked on the remote from making changes.

Convert the .MDB into a .MDE (Tools > Database Utilities > Make MDE
File...). No design changes can be made in an .MDE.

Important bit of pedantry. Use your MDB as the source to create a NEW file
that is an MDE. It is not really a conversion. The important bit is that
you need to keep your copy of the original MDB because that is the only one
you can use to make future design changes to.

 

[missinglinq via AccessMonster.com]

I agree with Klatuu! Some "Sister Mary Margaret Discipline" applied with a
steel-edged ruler would be appropriate!

 

[Klatuu]

Nobody expects the steel-edged ruler!
(if you are under 40, this probably makes no sense to you)