Capture User/Machine ID

[bmagg247]

I'm in a multi-user environment across half-a-dozen cities and I need to capture the User and/or machine ID.

I know the .ldb file lists the users machine name, but how can I capture that as part of the record that they are entering?

I need to know who is entering which records in case I need to contact them regarding their entry.

 

[KDg]

Hi,

you should be able to pull them up with
environ("computername")
and
environ("username")

HTH

Drew

 

[bmagg247]

Thanx, it worked!

One thing else. Access does a poor job at documenting the environment variables (among other things). Where can I find a list of them?

 

[KDg]

I don't know to be honest, but you can see them by doing something like

dim x as integer
for x=1 to 50
debug.print environ(x)
next

there seem to be 46 on my pc but i guess it varies so you may need to up it from 50. The name you can call each of them with is then to the left of the =.