Locking Design View?

[Andrea]

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

 

[Klatuu]

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.

 

[Andrea]

Okayyyy...

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


Thank you Klatuu.

 

[Douglas J Steele]

Look under Tools | Database Utilities

 

[Andy]

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