Posted by Aaron Bertrand [SQL Server MVP] on 04/05/07 02:54

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.googlegroups.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
>

• Next in forum: Re: Compact and Repair in an adp
• Prev in forum: Capture NT User ID
• Thread view: Re: Capture NT User ID

[Reply to this message]