Lock user in a form

[joeyjojoshabadoo]

I have my database setup so it opens right to the form i want them to use.
I do not want them to see any tables, etc.
So their only option should be to close out of the database when done with the form.
Easiest way to do this?

 

[bradcccs]

Acc97:

Tools - Startup

Select correct form
Remove "display database window"
Remove "allow full menus"

Remember to add navigation and exit buttons to form if necessary.

This is by no way fool proof, but is easy.

You can bypass the startup options by holding the "Shift" key down when opening your database. Therefore, it is not real secure, but again - is easy.

hth
Brad

 

[joeyjojoshabadoo]

I already did that, but those options (along with the shift) still allow them to exit a form or swirch windows into the database

 

[Chris RR]

Are your forms' Modal and Popup properties set to yes? Have you turned off the Control Box, Min Max, Close and What's this properties for your forms (or found a combination you like)? You can also create a blank Menu Bar to shut down that option for the users.

 

[KeaganQuilty]

Do what Chris RR said and change all those important properties. Then, add a command button to your form and put the following line in the OnClick Event

Application.Quit

This will close down Access altogether.

Keagan Quilty
Kilbride, Newfoundland

 

[KeaganQuilty]

Come to think of it, you can disable the Shift Key bypass, but for the life of me I can't remember how to do it.

Keagan Quilty
Kilbride, Newfoundland