HOW CAN I TELL WHO IS ACCESING AN ACCESS DATABASE?

[r.sponsler]

How can I tell who is accessing an access database so that I can tell them to
get out.?

 

[Rick B]

You really can't unless you store that data as each user logs on. You would
need to incorporate some type of logging into your database. You could also
have a form open (hidden) with a timer event to check a value in the
back-end every five minutes or so. If you need everyone out, you could
change that value. Your hidden form could be coded to become visible and
display a message stating that the administrator is about to close the
database. When the value is further changed, the form's code could
docmd.quit to kick them out.

Lots of ways to do it. Do some searches.


You might also try copying the .ldb file and then opeining it with Wordpad.
That will show you who has gotten in it recently.



Rick B

 

[Jeff Conrad]

Hi,

I do not have any personal experience with this task, but see if these links help.
Watch out for any possible line wrapping on these links!

http://www.datastrat.com/Download2.html
Look for KickEmOff2K sample database.

http://www.rogersaccesslibrary.com/download2k.asp?SampleName='LogUsersOff2k.mdb'

http://www.rogersaccesslibrary.com/download2k.asp?SampleName='LogUsersOffNonUse2k.mdb'

http://support.microsoft.com/?id=198755

http://support.microsoft.com/?id=285822

http://www.candace-tripp.com/_pages/access_downloads.asp
Look for Detect and Logoff Idle Users

Hope that helps,

 

[Todd Shillam]

You can use a simple batch file to append details to a text file. Not only
that, you could send an alert straight to your computer desktop too by using
'netsend' command.

Are you comfortable coding a little VBA (Visual Basic for Applications) in
Access? If you have a form that opens (such as a splashscreen, switchboard,
or main menu), you can use the OnTimer event to call your batch file:

***************** CUT HERE********************

Private Sub Form_Timer()

'=========================================
'DATE: September 30, 2004
'AUTHOR: YourNameHere
'COMMENTS:
'
'1) This subroutine launches a MS-DOS
'batch script.
'=========================================


'DECLARING VARIABLE
Dim strAppName As String

'INITIALIZING VARIABLE (USING A MAPPED DRIVE)
strAppName = "R:\YourBatchFileName.bat"

'CALLING MS-DOS BATCH SCRIPT TO PERFORM APPLICATION UPDATE
Call Shell(strAppName, 1)

End Sub

***************** END HERE********************

Then you create a batch file that records whomever is opening the
application, including the computer they are using. Morover, you can send
yourself a message at the same time. Here's an excerpt of code on the
netsend command:

netsend YourLoginNameHere "%USERNAME% has just launched the program." > nul

However, a better solution would be just to make sure they can't use it to
begin with. You can code a splashscreen to prevent unauthorized users with
access.

Best regards,

Todd

 

[A. J.]

Microsoft article 198755 - How to determine who is logged on to a database by
using Microsoft Jet UserRoster in Access 2000.