Securing a database (1 Viewer)

Have done it loads of times before but for some reason this one don't work

Created a new user "harrisw" and a new group "supervisor" and put a password on it so the login prompt appears.

Removed all the ticks from database, tables etc for both the admin and users groups and put ticks in all the boxes for the supervisor group.

However if I double click the mdb file instead of using the icon that i've got that points to the mdb file, the database still opens. I was expecting access to grumble because the admin(default account) doesn't have any permissions

Is there something I'm missing?

You probably have not been renaming the security work group file (system.mdw by default). Without a differing name if Access is able to find an unsecured system.mdw file it could be using that one instead (generally located in C:\Program Files\Common Files\System.

Autoeng

Now thats confused the problem more as i've never done this before but all the other databases work.

I do have a system.mdw file in the winnt\system32 directoy. Surly though if you remove all the admin priviliges from the mdb file then it shouldn't load.

I would suggest that you read the Microsoft Security FAQ located here...

http://support.microsoft.com/default.aspx?scid=/support/access/content/secfaq.asp

Autoeng