Just how dangerous is this user - perhaps you can speak to management about
their mischief?
You can do a fair amount to shut out the curious, however since users need
access to the file, you cannot stop a determined hacker.
There are a number of things you can do:
Backup your database; you can easily lock yourself out playing around with
these features.
Create custom menus/toolbars for use throughout your application.
Create a startup form (a main menu form if you have one) that is opened on
startup.
Use the features in Tools, Startup to
set the startup form
set your default menu (the custom one you made)
disable all the checkboxes about allowing built in menus, toolbars,
changes etc.
hide the db window (ensure the custom menu you create does not
include the Windows, Unhide item
Click on the Advanced button and uncheck the allow special keys
(this will disable the F11 key, among others)
If you need to bypass these startup features, you can hold the shift key
down while you open the db. If you feel that your user may use this to
bypass your settings, you can disable the shift key bypass - there's an
example in help for doing this(look for AllowBypassKey) or at
http://www.mvps.org/access/modules/mdl0011.htm
and
http://www.mvps.org/access/general/gen0040.htm
You can also create a MDE from your database, which will prevent changes to
forms, reports and modules (If you do this, be certain to keep your original
mdb in case you need to make changes).
That may be enough to keep them out while you implement user security.
Download and *study* the security FAQ. Follow the steps outlined exactly.
Finally, I'd suggest that if this person has taken an Access class, they
will learn something. You'd be better off to provide them with the
capability to use their new skills. Frustrating them will only encourage
them to break in. With security you can deny them the ability to delete or
update data, while still allowing them to run Select queries and create
reports.
