Access 2003 Database Security

[Norsouth]

I'm very new to this site, and I think I may have made a mistake. I'm an Administrative Assistant who is very new at creating Data Bases. The question that I need answered is how can I assign security measures that will stop users of the database from changing any of the designs in my forms. I also do not want any user to be able to get to my tables, etc.

Simply put, I need a step by step solution to my question. I have tried creating user accounts and granting limited permissions, but each time I run into a wall.

If anyone can help me, I really would appreaciate it.

Thanks to all.

[MMcCarthy]

I'm very new to this site, and I think I may have made a mistake. I'm an Administrative Assistant who is very new at creating Data Bases. The question that I need answered is how can I assign security measures that will stop users of the database from changing any of the designs in my forms. I also do not want any user to be able to get to my tables, etc.

Simply put, I need a step by step solution to my question. I have tried creating user accounts and granting limited permissions, but each time I run into a wall.

If anyone can help me, I really would appreaciate it.

Thanks to all.

Have a look at this tutorial and see if it will help.

http://www.thescripts.com/forum/thread610723.html

[Lysander]

I'm very new to this site, and I think I may have made a mistake. I'm an Administrative Assistant who is very new at creating Data Bases. The question that I need answered is how can I assign security measures that will stop users of the database from changing any of the designs in my forms. I also do not want any user to be able to get to my tables, etc.

Simply put, I need a step by step solution to my question. I have tried creating user accounts and granting limited permissions, but each time I run into a wall.

If anyone can help me, I really would appreaciate it.

Thanks to all.

Access has very good security controls, but they are not self-evident. A full step by step solution to Access security is quite complex but I can get you started. I suggest getting hold of a copy of Access Developers Handbook by Litwin and Getz for a full explanation.

First you need to create a new mdw security file. To do this in 2003, open any database and then from the tools menu, select Workgroup Adminstrator.

Create the new file, then join it.

Now you are in the new mdw, create a new account, say 'owner' and make it an administrator. Set a password for the default Admin account

Log out, then start access again, login as owner and create a new blank database.

You now have a empty database, created by 'owner'

Go into the security tools and remove all the groups from the default accounts, i.e. Admin, User. Set a password for owner.

Create a new GROUP called staff or whatever. This group will be what your users will use.

Go into the permissions tool and revoke permissions on database, table, query, form etc etc for default USERS and ADMIN. Make sure that owner has full permisions on everything.

You can now assign permissions to the STAFF group. If you have different levels of users, create a new group for each level and assign correct permissions.

Create accounts for each user, and assign them to the STAFF or appropriate group.

If all of this works, you now have a secure database. You can now import all of your tables and code from the unsecure database into this one.

Note that your users will only be able to access this database via the new mdw file. I use the following shortcut to do this.

"C:\Program Files\MICROS~2\OFFICE11\MSACCESS.EXE" c:\Bissau\BissauCode.mdb /wrkgrp Z:\Bissau\Bissau.mdw
 

[Norsouth]

Have a look at this tutorial and see if it will help.

http://www.thescripts.com/forum/thread610723.html

Thank you very much for your help, I will try it.

[Norsouth]

Access has very good security controls, but they are not self-evident. A full step by step solution to Access security is quite complex but I can get you started. I suggest getting hold of a copy of Access Developers Handbook by Litwin and Getz for a full explanation.

First you need to create a new mdw security file. To do this in 2003, open any database and then from the tools menu, select Workgroup Adminstrator.

Create the new file, then join it.

Now you are in the new mdw, create a new account, say 'owner' and make it an administrator. Set a password for the default Admin account

Log out, then start access again, login as owner and create a new blank database.

You now have a empty database, created by 'owner'

Go into the security tools and remove all the groups from the default accounts, i.e. Admin, User. Set a password for owner.

Create a new GROUP called staff or whatever. This group will be what your users will use.

Go into the permissions tool and revoke permissions on database, table, query, form etc etc for default USERS and ADMIN. Make sure that owner has full permisions on everything.

You can now assign permissions to the STAFF group. If you have different levels of users, create a new group for each level and assign correct permissions.

Create accounts for each user, and assign them to the STAFF or appropriate group.

If all of this works, you now have a secure database. You can now import all of your tables and code from the unsecure database into this one.

Note that your users will only be able to access this database via the new mdw file. I use the following shortcut to do this.

"C:\Program Files\MICROS~2\OFFICE11\MSACCESS.EXE" c:\Bissau\BissauCode.mdb /wrkgrp Z:\Bissau\Bissau.mdw
 

Wonderful, thank you very much. I will try it and see what happens.