beginer security problems

[Guest]

Hi,
in order to set my security ie. users and their passwords in my mdb, I
replaced my System.mdw with new one with default administrator user Admin (no
password) excluded and with my new admin user and 'common' users.

Everything seems to work fine until that new mdw file is deleted (lets
suppose that
someone can delete it, on purpose or not). After custom mdw file is deleted
Access creates default System.mdw file again and
now anyone can enter mdb and can do anything.

There must be protection if someone simply deletes mdw file?

Thanx

alekm

 

[Rick Brandt]

Hi,
in order to set my security ie. users and their passwords in my mdb, I
replaced my System.mdw with new one with default administrator user Admin (no
password) excluded and with my new admin user and 'common' users.

Everything seems to work fine until that new mdw file is deleted (lets
suppose that
someone can delete it, on purpose or not). After custom mdw file is deleted
Access creates default System.mdw file again and
now anyone can enter mdb and can do anything.

There must be protection if someone simply deletes mdw file?

If you can open your secured file with ANY mdw besides the one used to
secure it, then you didn't secure it properly. For one thing the default
user "Admin" MUST have a password or else no one will be prompted to
provide a UserName and Password.

The user "Admin" must own nothing and have permissions to nothing. The
default group "Users" must have permissions to nothing. Then if someone
attempts to open with another MDW file they will be denied.