By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,098 Members | 1,927 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,098 IT Pros & Developers. It's quick & easy.

how to get SQL2k user ID passed to Access

P: n/a
I have an Access front end with ODBC drivers to a SQL2k box. All our
security is Wiondows-authentication on the back end, we don't use Access
security workgroups. THerefore when I try to get the userID for the
CurrentProject object (if memory serves), it returns "Admin" for every user.

Is there a way to run a query (pass-through if necessary) that will go
grab the SQL2k User and return it to Access?

TIA,
--
Terrell Miller
mi******@bellsouth.net

"Every gardener knows nature's random cruelty"
-Paul Simon RE: George Harrison
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Terrell Miller wrote:
I have an Access front end with ODBC drivers to a SQL2k box. All our
security is Wiondows-authentication on the back end, we don't use Access
security workgroups. THerefore when I try to get the userID for the
CurrentProject object (if memory serves), it returns "Admin" for every
user.

Is there a way to run a query (pass-through if necessary) that will go
grab the SQL2k User and return it to Access?


Passthrough select query:

select user

or

select system_user

depending on what you want, system_user returns the login name, user
returns the login name except for the dbo, in which case it returns
"dbo" :-)

--
This sig left intentionally blank
Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.