Locking Design View?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

We have a form on a computer that students use to scan in their ID cards to
reserve a study spot in our library. Recently, we caught some clever student
fiddling with the form in Design View.

Is there anyway to prevent someone from getting into Design View on a form?
In other words, can we lock on Form View and lock out Design View?

Thanks
 
Not if you have really clever students. You best bet is to create an mde
file and deploy that rather than the mdb. Keep the mdb in a location to
which students have no acccess. You could also investigate implementing Jet
security.
 
Okayyyy...

How do I make an mde file? I've never heard of that before :/


Thank you Klatuu.
 
Hi Andrea,

Hope you are well, try this:

Goto Tools - Database Utilities - Make MDE File

An MDE is basically an executable DB file which disallows designing and
encrypts the VBA coding

Hope this helps

Have a lovely day!

Andy
 
Back
Top