DBAchick
Programmer
- Apr 27, 2000
- 61
External Customers use trusted connections through Windows NT to access SQL Server and their user accounts are domain\username which gets them into their own application1.
I have an application2 with an Access97 frontend and a SQL Server 7.0 backend. I want these external customers to log into SQL Server as usual and have an option on their desktop to launch application2. Upon launching it, I need to know who is loggin in within the Access97 frontend of application2. I tried user_name, but it returns Admin because no matter who is logging in, it is going through the Admin account.
I am not going to be able to use Access97 security accounts, this must be seamless to the external customers.
Is there a way to capture the NT/SQL login name and capture it within Access?
Thank you for any suggestions!
DBAChick
I have an application2 with an Access97 frontend and a SQL Server 7.0 backend. I want these external customers to log into SQL Server as usual and have an option on their desktop to launch application2. Upon launching it, I need to know who is loggin in within the Access97 frontend of application2. I tried user_name, but it returns Admin because no matter who is logging in, it is going through the Admin account.
I am not going to be able to use Access97 security accounts, this must be seamless to the external customers.
Is there a way to capture the NT/SQL login name and capture it within Access?
Thank you for any suggestions!
DBAChick
