get the user name from an access project

• lior gal

  SSC Journeyman

  Points: 94

  More actions

  October 12, 2004 at 1:29 pm

  #162838

  HI

  i'm runing sqlserver 2000 with an access project as the front end.

  In want to use sqlserver security and I cant find out how to get the user name on the server from the access project. (i need it to keep the name of the user that updated some fields)

  using sql-dmo i can connect to the server  and get the login name and yser name but i need to provide the login name and pass to connect, the very login name that i want to find.

  Is there any way to save the login name in avariable after the user login?

  is there another way to get the login name or the user name of the current user/login with out sending it to the server ?

   

   

• anna docwra

  SSC Rookie

  Points: 48

  More actions

  October 13, 2004 at 7:19 pm

  #526620

  you can declare a global var in a form and assign it and hide the form