auto current_user field from MSDE/SQL Server

[David P. Lurie]

Access 2003
MSDE

How do I get current_user from MSDE/SQL Server into a text box to use in a
before_update procedure on a form? The Access current user function just
gives Admin, similar to a default non-secure mdb.

SELECT current_user; will get the current user. Will this require
significant ADO programming to capture, or is there a simple property to get
this instead of the Access user?

Thanks,

David P. Lurie