Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Group name in access security

Status
Not open for further replies.
Grieve1

Grieve1

Programmer
Jun 11, 2008
33
GB
I have set up security on a database and have used Application.Currentuser to record the username so as they can have forms allocated to them and what I was looking to do is record the user groupname so as I can allocate forms to specific groups. If it is possible
 
Sort by date Sort by votes
A user may be a member of more than one group:

DBEngine.Workspaces(0).Users(Application.CurrentUser).Groups(0).Name
 
Upvote 0 Downvote
Many Thanks Remou for this. Yes I do know a user can be in more than 1 group but going to try and avoid this as best I can.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

M
  • Question
display a calendar with appointments in body of html email with access vba
Replies
1
Views
448
SoftwareRT
SoftwareRT
Moss100
  • Locked
  • Question
Access send email attachments - problem when null or empty
Replies
7
Views
447
Andrzejek
Andrzejek
bobbyer
  • Locked
  • Question
ms accesss option group on report
Replies
4
Views
133
bobbyer
bobbyer
Moss100
  • Locked
  • Question
Open New Access Database and Maximise the Application Window
Replies
0
Views
233
Moss100
Moss100
Moss100
  • Locked
  • Question
Stop user changing size of Access Application (not form)
Replies
1
Views
411
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top