Protecting database

[Damo10]

Hi,

I have written a simple databse for work and they have requested that the file be protected from unauthorised access.

How can i password protect the database and also block access to the backend to all users but myself? I would also need to block the shift bypass.

Is it possible to prompt for a password on opening the databse and have a user level password that only gives them access to the form and an admin level password that shows the backend? I know I can set a password to open but I would like to be able to do it without going through the open exclusivle route if possible.

Any help would be great

I am using Access 2003 at work.

 

[SydneyGeek]

Hi Damo10,

There are several questions here so I will break them up:

How can I password protect the front and backend?

Place the backend in another directory. All users of the db need read-write access to that directory or they will not be able to open the database. Don't advertise the location of the directory...
And you will need to password protect both the front and backend by going into Exclusive mode.
Note: once you password protect the backend the links won't work so do this --
Delete all table links
File > Get External Data > Link
Browse to the db; you will be prompted for the password.
Select all tables and link.

How do I prevent Shift bypass?

In code. There is a good example here. Make sure that you do this on a copy of the front end; keep an unmodified copy for development, so you have a fallback.

It also means that you have a locked-down version for general use, and a dev version for yourself.

Denis