user only allowed to use the form and can do nothing else outside of the form

[joe789]

Hi Folks,

I am wondering if someone can help me determine someway to setup a microsoft access database that I have so that the user can do nothing at all besides using the input form that I created and that automatically opens and is maximized via the autoexec macro. The reason for this is because although the user does need to use the form to enter or edit data, I do not want the user to close out the form and start playing with the data table or queries outside of the form. Is there a way where if the user closes the form, it will re-open very quickly so that there is no way they can do anything but use the form ... or some method that anyone knows about that might work. I really appreciate any help I can get, because this is for a non-profit governmental agency and this is the final piece that I would like to impliment before roll out into production on Monday.

Thank you,

Joe

 

[Vassago]

Go to tools-> Startup

Choose the form you want to display under the first combo box.where it says "Display Form/Page".

Uncheck all boxes that appear there.

Follow these instructions to disable the shift bypass key:

http://www.databasedev.co.uk/disable_shift_bypass.html

Make sure you have a backup copy in case you lock yourself out completely after disabling the bypass key.

Vassago