SQL Server Username (Access XP)

Topic

New Reply

I have code that captures the Windows user name and time for the last user to make a change to a form, and I have used the same type of code for Access using the Access .mdw username. Is there a way to capture the SQL username from the backend tables to record the last user to make a change?

Carla

Reply | Quote

Replies

See Retrieve (Get) SQL Username from SQL Server using VBA code and Access 2003 (DAO) or Get user name within vba (ADO).

Reply | Quote

Hans,

Thank you for the link. I tried the ADO version and had trouble with it, DAO version worked fine.

Carla

Reply | Quote