Securing Access DB

[Summerking]

Hi all

I am trying to find a best way to secure access 2003 db if it will be
distributed to general users. The target is to prevent the users open the db
to view and modify it. All users should access and modify the db using the
application program designed for them. I tried the followings:

- Database Password: doesn't work, the password recovery tools find the
password instantly.
- secured.mdw: same, doesn't work, the password recovery tools find the
password instantly.
- using Wizard, and the steps as suggested by Access Secrutiy
FAQ(Microsoft): no help on password protection.

The main problem is the password protection in access is weak. Of course it
cannot be 100% secured. But I think it should not as easy as to find a
password recovery tools and do it instantly.

Any workaround or suggestions.

Thanks.

 

[Rick Brandt]

Hi all

I am trying to find a best way to secure access 2003 db if it will be
distributed to general users. The target is to prevent the users open
the db to view and modify it. All users should access and modify the
db using the application program designed for them. I tried the
followings:
- Database Password: doesn't work, the password recovery tools find
the password instantly.
- secured.mdw: same, doesn't work, the password recovery tools find
the password instantly.
- using Wizard, and the steps as suggested by Access Secrutiy
FAQ(Microsoft): no help on password protection.

The main problem is the password protection in access is weak. Of
course it cannot be 100% secured. But I think it should not as easy
as to find a password recovery tools and do it instantly.

Any workaround or suggestions.

Thanks.

If data needs to be secure from *users* then it should not be stored in an MDB
file (or any other file-based database).