Setting security users and permissions

Question

Setting security users and permissions

ritesh-296675

Say Hey Kid

Points: 678
More actions
March 16, 2006 at 8:00 am

#67345

Hi,
I need to set up users and permissions. I used the wizard. But when I click on the database I'm always logged in as admin.
I want users to enter their own username and password. So if there's a group the users will sit in the group. This group should allow them to add data to the forms.
As mentioned before I want them to click on the databsae and then add their username and password.
How Do I do this? Help

Viewing 15 posts - 1 through 15 (of 16 total)

You must be logged in to reply to this topic. Login to reply

Ray M SSC-Insane Points: 21093 More actions · Answer 1

I do not believe there is a way to do this.

The user granting privileges must have access to the database, There is no way for a user to grant themselves privileges.

I may be confused of exactly what your asking.

ritesh-296675 Say Hey Kid Points: 678 More actions · Answer 2

when the database is opened it will ask the user for a name and password. If correct then the database will open. Similar to the password setup.

Is that a bit clear?

regards

ritesh

Ray M SSC-Insane Points: 21093 More actions · Answer 3

Ray M

SSC-Insane

Points: 21093

March 16, 2006 at 8:25 am

#627046

Sorry, Your using access, I missed that part.

Chutney Old Hand Points: 393 More actions · Answer 4

Here is a link with which to start:

http://www.drewslair.com/desk/access_series/add_security.htm

dplaut Old Hand Points: 321 More actions · Answer 5

1) unless you deny access to user Admin you have not really accomplished anything.

2) You have to start Access via a shortcut that names the system.mdw that has the security you want to use.

something like

"C:\Program Files\MSOffice97\Office\MSACCESS.EXE" c:\mypath\mydata.MDB /wrkgrp c:\mypaty\system.mdw

3) To use Access security effectively you need to read everthing you can get your hands on. Previous mentioned link is a good start.

dplaut Old Hand Points: 321 More actions · Answer 6

and 4, this book is the bible on Access security.

http://www.amazon.com/gp/product/1590591267/102-3462380-0344916?v=glance&n=283155

WILLIAM MITCHELL SSChampion Points: 13766 More actions · Answer 7

WILLIAM MITCHELL

SSChampion

Points: 13766

March 17, 2006 at 2:23 pm

#627437

Did you set a password for the Admin user?

ritesh-296675 Say Hey Kid Points: 678 More actions · Answer 8

i've set up a password. But it stll not working properly.

I thought it wqould simple to create some users and when they logn add their pwd and username and then they're logged in.

Regards

Ritesh

Metra Christofferson Ten Centuries Points: 1153 More actions · Answer 9

If you're not using the username and password for security purposes (if they add their own, it isn't security), but for audit trail purposes, you could just query the machine name, NT Username or whatever, and use that for the audit trail, but that wouldn't use Access Security.

For security, someone (you, some person you assign privileges to, whoever -- the "security administrator") would have to determine that said user (for example, "Joe") should be able to log in to the database and the "security administrator" then creates Joe's login and THEN Joe can login.

The "security administrator" who grants the privileges could have a form that lets them type in the user name, pick the user group from a list and make up a password and then press a button to add "Joe" to the list of users. The "security administrator" would have to have administrative privileges to do it.

dplaut Old Hand Points: 321 More actions · Answer 10

Setting a password for the admin won't do anything. Anyone with a copy of system.mdw (that is everyone) will have an admin user in there w/out a password and will be able to open the database.

You must deny all rights to the user admin! There can be absolutely no exceptions to this. You can't learn access security via a forum. You have to read the knowledge base articles or a book.