DB Security for an Access 2003DB

[Johnny Drama]

Hopefully this should be pretty simple, but I'd like to get some feedback from you pros.

I've created a DB in 2003 that will be placed on a network share for the 5-6 users who will be using it. Basically there are two user groups that will be using the DB, so I'm creating Group1 and Group2 and placing the appropriate users in each group.

My question is this: The user names I'm placing in the DB user groups mirror the users domain login account, which is also the same account name that is used to log into their workstation. Will Access use their domain login (user name) so that the permissions applied to the access groups are applied in turn to the user?

There's no need for super strong security here....it's just more of a control for users to access the proper forms for data entry...

 

[Banana]

The thing is that Access has no knowledge of Windows permissions so it wouldn't matter one whit if the user had a credential but nothing on Windows domain.

One way to do a sanity check is to call an API that give you the logged in user's domain name and compare this to the user's username in Jet security and on mismatch, force quit.

If you search the forum, I'm sure you can find the API mentioned for checking domain name.

HTH.

 

[HiTechCoach]

For Network User name see:

http://www.mvps.org/access/api/api0008.htm