Find the remote userid causing updates on my table Small question here. I found some answer close to it but not exactly what I'm looking for.

Here is the situation: I have a SQL Server trigger on a table. Its task is to record the username (logon id) of the user who make some insert/update/delete.

So far, it's not so hard to find the information.

The complicated part is coming. The insert statements are made through an Access view with a generic SQL Server account.

What I want to do is find the (Windows) user that launch Access. I was able to find the host name (the name of the computer) but how can I found the user?

Thanks!
You cannot, if you are using a generic username to log in to SQL Server. Host name is as close as you can get. It shouldn't be hard to translate it to a user name with a query in Active Directory.