Access Security and Domain Login's

[LBitner99]

All,

I tried my damnedest to find something about this elsewhere in the forums but drew a blank.. so i figured I'd see what asking the question direct yeilds.


I would like to initiate workgroup level security to my database. but have no password required because i want to tie it to the username that is logged into the computer when the user logs into the domain initially? any thoughts?

 

[ghudson]

User level security should be set for a specific group who have specific needs of the database. You should not set the security for a specific person.

You can not customize the Access login that requires a user ID and password when you use workgroup secutity.

You can secure the db with a custom workgroup and user permissions and have the users open the db with a custom shortcut so that the user does not have to log in with a user name and password just to open the db. Then you can build a custom login inside the database.

Not sure what you are trying to do so more information is needed from you.

 

[LBitner99]

ok here's how it is:

I know for a fact that here at my office there was once a database that was tied to your windows login name. depending on the windows login name (and i would then assume what local security group you were tied to) you were allowed specific security access to the database.. but no password was ever needed to open the database.. if you were on the list of people who could access it, then it would open for you. i am trying to recreate that.. i dont have the old database that DID that to reference so i feel im at a bit of a loss.