Other Users

[Guest]

Hi,

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


Regards,
Ron

 

[Guest]

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.

 

[Guest]

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

 

[Keith W]

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.

This is not necessary. Google for LDBView.exe.

Keith.
www.keithwilby.com

 

[Guest]

Thanks Guys,

I can see uses for all of your suggestions.


Regards,
Ron