If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Other Users
Hi,
Is there any way to tell which users are connected to a shared Access database? Regards, Ron |
#2
|
|||
|
|||
Other Users
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" wrote: Hi, Is there any way to tell which users are connected to a shared Access database? Regards, Ron |
#3
|
|||
|
|||
Other Users
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 "Ron" wrote: Hi, Is there any way to tell which users are connected to a shared Access database? Regards, Ron |
#4
|
|||
|
|||
Other Users
"KARL DEWEY" wrote in message
... 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 |
#5
|
|||
|
|||
Other Users
Thanks Guys,
I can see uses for all of your suggestions. Regards, Ron "Conrad" wrote: 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 "Ron" wrote: Hi, Is there any way to tell which users are connected to a shared Access database? Regards, Ron |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Protect Workbook vs Worksheet?? | Dan B | Worksheet Functions | 3 | November 7th, 2005 09:02 PM |
Share Users Detailed Outlook Calendar and Make it Dynamic | rvaldes | Calendar | 3 | October 11th, 2005 04:57 PM |
How to remove the dead link to other user's folder (Calender)? | John Z | Calendar | 2 | March 10th, 2005 05:41 PM |
Protecting Workbook | Paul Cooling | General Discussion | 2 | March 7th, 2005 11:55 AM |
Other User's Folder | [email protected] | General Discussion | 2 | June 15th, 2004 08:24 PM |