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 Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

test for SQL Server Role in VBA

Status
Not open for further replies.
lorirobn

lorirobn

MIS
Mar 15, 2005
450
US
Hi,

I am running an Access Front End with SQL Server 2000 Back End. I have set up a few different Roles on the Server, including one of Manager. I have added a command button on one of my Access forms that will only be seen by one user (manager), but I don't know how to check for this.

Using VBA, how can I test for the SQL Server role the current user belongs to?

(I am not sure the appropriate forum to post this on, so I will try it on VBA Coding and SQL Server programming.)

Thanks in advance.
 
Status
Not open for further replies.

Similar threads

renigar
  • Locked
  • Question
Access VBA Syntax Error 1
Replies
5
Views
3K
Andrzejek
Andrzejek
ameedoo3000
  • Locked
  • Question
format partition by vba code
Replies
6
Views
743
mattKnight
mattKnight
renigar
  • Locked
  • Question
Access 365: Search LastName in one table to put EmployeeID in another
Replies
8
Views
721
renigar
renigar
TheresAlwaysAWay
  • Locked
  • Question
How can I make Access display a + sign in front of positive integers, just as it does - for neg? 2
Replies
8
Views
3K
TheresAlwaysAWay
TheresAlwaysAWay
Bubba002
  • Locked
  • Question
WHERE clause in the Set command of an db.OpenRecordset method
Replies
16
Views
809
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top