User-level security for a DB that will be in other workstation

[Bresart]

Hi, in a DB that will be provided to multiple users for their particular use, does user-level security have any sense?

I mean, if in my workstation where the DB has been made i have an 'Administrator' account with password and a 'User' account without password, if in another workstation there's no user account created, will the dialog box asking for which user is entering appear in this DB opening in that other workstation?

Thanks for any help given.

 

[lameid]

I am assuming you mean you have created your own workgroup and have joined it.

All workgoup files have 2 things in common (assuming they are created with the same version of Access). The Users Group and Admin user are the same accross all workgroups. So any permission you give admin or the users group will be available to anyone that opens the database with the default workgroup.

Unless the user is specifies a password for admin they will log in by default as the Admin user which is by default a member of the users group.

In short you can be the owner of all the objects and give users/admin permisson to only do certain things in effect only allowing genric users a certain level of permission. I hope that clears it up for you.

 

[Bresart]

Thanks lameid.

You speak about a workgroup in a specific workstation. About that, only a doubth:

1.- Is a workgroup the whole users groups and user accounts?

And, i was asking about what happens in different workstations:

2.- will the user-level security in the DB be in each case (in each workstation) the stablished in that workstation?

3.- So, if i specify a password for the DB for the Admin user in my workstation, and in other workstation there's another specified password, will the DB in that other workstation ask for the admin password that is specified in that workstation or for the stablished in my workstation?

4.- So, if i specify a password for the DB for the Admin user in my workstation, and in other workstation there's no specified password, will the DB in that other workstation ask for the admin password that is specified in that workstation or won't ask for any password?

 

[lameid]

1 Yes... You can join a workgroup (Tools, Security, Workgroup Administrator <Join Button>) or use the defualt and modify it or not. You can also start Access with a specified workgroup using the command line switch /wrkgrp

2. The security in an MDB is related to the PID's of the users and groups of a workgroup (.mdw file). Some PID's are common to all workgroups (Users Group and Admin user) and others are only if you specify them (not likely to happen by coincidence). So every workgroup has skeleton keys for Admin and Users and keys can be copied into by specifying the PID. Each workgroup maintains its own user and password separately so the password grants access to a key / PID but the same PID may exist in another worgroup with a different password. Both will allow entry.

3. The password specified on the workstation running Access will be run... Or more specifically the password for the user for the workgroup Access is using (either the joined workgroup or the one specified via the command line).

4. Yes... Passwords follow the workgroup (.mdw) not the .mdb.

 

[Bresart]

lameid thanks.

Then, in a DB that will be provided to multiple users for their particular use in their worksations, user-level security has no sense. Is that correct?