How to Read login username from ADP

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

kai - 07 Aug 2005 01:08 GMT

Hi,
I have Access 2003 and SQL2k. I use ADP to connec Sql Login, after a user
enter his username and password in SQL Login, I want to read the username
(assign to varible)for Access programming. How do I read the username in
Access after a user login?

Thanks

Kai

Reply to this Message

giorgio rancati - 07 Aug 2005 11:16 GMT

Hi Kay,

----
SYSTEM_USER
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_sysu
sr_3c8i.asp
----

in VBA
----
strUserName=Dlookup("system_user","sysobjects")
----

Ciao
Giorgio

> Hi,
> I have Access 2003 and SQL2k. I use ADP to connec Sql Login, after a user
[quoted text clipped - 5 lines]
>
> Kai

Reply to this Message

kai - 07 Aug 2005 17:27 GMT

Hi Ciao,

Thank you so much, it works like magic.

Kai

> Hi Kay,
>
[quoted text clipped - 21 lines]
>>
>> Kai

Reply to this Message