Enhanced security to the access database?

[panadoll]

Hi,

Currently, I am using the access 2000 database password to protect the database. However, i think that it is not sufficient. Therefore, I would like to find out whether there are any software or any feature in the access where i can enhance the security of the database.

Any software or add-in or available features in access that you can recommand?

Thanks in advance...

 

[PaulBricker]

The Access password and Access Security are two different things. You can read up on Access Security here:

http://www.moretools.com/lessons/access_security.htm

or here

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

or just type MS Access Security in Google and find a lot of info.

Paul

 

[psemianonymous]

Oh yeah, and I wrote a FAQ that gives an overview on your options with Access security. faq181-3893

 

[AccessHawaii]

panadoll,

The database password really doesen't offer any type of protection because everyone that knows the password has complete access to everything in the database. The best way to secure is to create a workgroup and then add yourself as a user and add "Admin" to your group and then remove the "Admin" group from the "Admin" user, which is the default and also set a password for the "Admin" user. After doing that, close the database and log back in with the new account that you created and make sure that you set the "users" group to have no permissions to anything in the database and then go ahead and run the security wizard, which will automatically attach to the workgroup that you created and signed in under, After that you can go ahead and create your user's accounts and groups and assign the permissions.