Login ID in access 2000

[Waynest]

I'd like to write the user login name to some records as they are updated. Anyone know how I can reference the user ID in an access 2000 .adp project? Access prompts for a sql server login when you open the project but I dont know how to get at it.

 

[Psychpt]

If you're looking for the sql login name and you're using sql 7.0 there's a built in system function called SUSER_NAME
you can use it in any sql statement.

Hope that helps.

 

[Waynest]

that should do the trick, thanks