Other Users

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

Is there any way to tell which users are connected to a shared Access
database?


Regards,
Ron
 
Yes, if you have Access security set up.

Read a lot first and make a backup of the database before starting to set
security. Write your passwords down and place in an envelope that you lock
up.
 
Ron,
Try this. Got this code a long time ago from a newsgroup. It will get you
the name of the user logged into a computer on a network.

****Code
Private S1 As String
Private Declare Function GetUserName Lib "advapi32.dll" Alias "GetUserNameA"
(ByVal lpBuffer As String, nSize As Long) As Long

Public Function FindUserName() As String
' Function that returns the name of the currently logged on user
' Example - MyString = FindUserName
S1 = Space(512)
GetUserName S1, Len(S1)
FindUserName = Trim$(S1)
FindUserName = Left(FindUserName, Len(FindUserName) - 1)

End Function

****End Code
 
KARL DEWEY said:
Yes, if you have Access security set up.

Read a lot first and make a backup of the database before starting to set
security. Write your passwords down and place in an envelope that you
lock
up.
Click to expand...

This is not necessary. Google for LDBView.exe.

Keith.
www.keithwilby.com
 
Back
Top