Access front-end, SQL Server 2005 backend.

I have users connected to SQL Server via a Microsoft Access user-
interface.
Connection is via NT login.

I want to log users' activities to the database with their userid.

How can I capture their NT User ID (via VBA in Access)?

Thanks,
Bubbles

You could create a view in SQL Server, I guess, like:

CREATE VIEW dbo.NTUsername
AS
SELECT [username] = SUSER_SNAME();

Now VBA should be able to query from that view in SQL Server just like it
would any other table or view...

--
Aaron Bertrand
SQL Server MVP
http://www.sqlblog.com/
http://www.aspfaq.com/5006




"bubbles" <bubbles.one@hotmail.com> wrote in message
news:1175737278.694527.78540@q75g2000hsh.googlegro ups.com...
> Access front-end, SQL Server 2005 backend.
>
> I have users connected to SQL Server via a Microsoft Access user-
> interface.
> Connection is via NT login.
>
> I want to log users' activities to the database with their userid.
>
> How can I capture their NT User ID (via VBA in Access)?
>
> Thanks,
> Bubbles
>