By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,699 Members | 1,243 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,699 IT Pros & Developers. It's quick & easy.

Access 2003 Database Security

P: 3
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.
May 30 '07 #1
Share this Question
Share on Google+
4 Replies

MMcCarthy
Expert Mod 10K+
P: 14,534
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
May 31 '07 #2

Expert 100+
P: 344
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.
Expand|Select|Wrap|Line Numbers
  1. "C:\Program Files\MICROS~2\OFFICE11\MSACCESS.EXE" c:\Bissau\BissauCode.mdb /wrkgrp Z:\Bissau\Bissau.mdw
  2.  
May 31 '07 #3

P: 3
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.
May 31 '07 #4

P: 3
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.
Expand|Select|Wrap|Line Numbers
  1. "C:\Program Files\MICROS~2\OFFICE11\MSACCESS.EXE" c:\Bissau\BissauCode.mdb /wrkgrp Z:\Bissau\Bissau.mdw
  2.  
Wonderful, thank you very much. I will try it and see what happens.
May 31 '07 #5

Post your reply

Sign in to post your reply or Sign up for a free account.