Locking down database

[Mark]

Hi,

I wanted to find out if there is a way to lock down a
database to not allow users to open up the database and
have access to everything (tables, queries, forms, etc.)?
Like when you hold down the "shift" key on the keyboard
and click open the file... you have full access to
everything.

I have a database that is broken into two separate files
(an administrator version and a user version). I will
have many users using the user side of the database, but
would like to lock down the file from having anyone
opening up the file and have access to everything.

Thanks!

 

[Albert D. Kallal]

You can just use the settings in the start-up menu to hide every thing.

As a option, you can also TURN OFF the shift key by pass.

You also as a habit should be distribution a mde to your users. A mde is
really a access run time file with all text, source code etc removed. It
means your users cannot modify the application EVEN IF they get in. So, in
addition to hiding the ms-access interface with the tools->start-up options,
you can also disable the shift key, and also use mde.

I would assume that you are running a split mdb arrangement with a front
end, and a back end of data. (it would be hard to figure out how you could
have two different versions otherwise working on the same data). So, it
sounds like you at least have split your mdb into two parts, and this is
very good!

If you need some shift key code, grab my example at:
http://www.attcanada.net/~kallal.msn/msaccess/msaccess.html

If you need an example of hiding the full ms-access interface using the
tools->start-up options, download the 3rd example of mine at:

http://www.attcanada.net/~kallal.msn/msaccess/DownLoad.htm

Try the above and play with it. Then exit, and use the shift key trick to
get in and see the settings I used. If you convert the above example to a
mde, and then disable the shift key, you would be quite locked out of seeing
ms-access.