Trying To Identify Machine IP Address 1

[davethegog]

Hi There

I'm trying to identify the IP address and or Machine Name as the users log on to a shared (10 users) access database. Any suggestions? Thanks in advance

Dave

 

[gerard1979]

Try something with the Environ(expression as String)
I'm not sure if it's in it, but
Private Sub LoopEnviron()
dim i as integer
for i = 1 to 30
debug.print environ(i)
next i
end sub
in Direct ?LoopEnviron gives the functions look if it's in it

 

[davethegog]

Thanks Gerard1979

Environ(1) gives the computer name which will allow me to tie in who's logging on where.

Cheers

Dave