Results 1 to 11 of 11
  1. #1
    cbende2's Avatar
    cbende2 is offline Competent Performer
    Windows 7 32bit Access 2013
    Join Date
    Jun 2014
    Location
    Louisiana
    Posts
    370

    Cool Access Tool

    Hello all,



    Is there any software out there that allows me to view the users in my database, and see which records they are in (if they are editing data or AFK in a record).

    I guess a transaction log of some sort with live updates constantly?

    Any thing out there like this?


    Thanks

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    48,843
    None that I know of.

    I use a login/logout procedure.

    Identifying which records are in active edit sounds complicated.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    cbende2's Avatar
    cbende2 is offline Competent Performer
    Windows 7 32bit Access 2013
    Join Date
    Jun 2014
    Location
    Louisiana
    Posts
    370
    Gotcha,

    Thanks June7

  4. #4
    Ajax is offline VIP
    Windows 8 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    7,994
    nothing specific - I have used something similar for tracking use activity which is displayed so the user can go back to a previous action if required. Basic log is along these lines

    tblLog
    LogPK autonumber
    UserName text 'who
    ObjectName text 'form/report opened
    Key number long 'id of record working on (0 means a selection)
    Action text 'view, new, updated, appended - but also print/export/email etc
    TStamp date 'default=now()

    the log is always appended in the open event of all forms and reports and again in the before update event if triggered.

    Updated actions can trigger an entry in an audit log to indicate what has been changed

    Printing/Exporting/etc actions can trigger an entry in another audit log with the parameters used such as startdate/enddate etc

    Note I don't specify the table (it can get too complicated with subforms, multitable recordsources etc) and since this is primarily for the users benefit they don't have a view on tables anyway. However it would be possible to extend it to include tables if you wanted to - you would just need a mapping table of some sort to map tables to forms

  5. #5
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    20,961
    There are any number of ldb viewers out there, such as:

    http://access.mvps.org/access/modules/mdl0055.htm

    I haven't used any, but it would surprise me if they showed the record being viewed/edited.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  6. #6
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    48,843
    Notepad++ can view content of ldb/lccdb file. It can even edit it. I had a db where the lccdb would not go away, even though there were no users with the db open. Could not delete the lccdb. Opening and closing the db did not help. The lccdb showed same 3 users. I used Notepad++ to delete the lccdb content and then I was able to delete the lccdb file. Db runs as normal.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  7. #7
    cbende2's Avatar
    cbende2 is offline Competent Performer
    Windows 7 32bit Access 2013
    Join Date
    Jun 2014
    Location
    Louisiana
    Posts
    370
    Hey paul, is there any way I can modify this for Access 2013? I was able to edit the code and add .accdb to select options, but once I choose my database it throws me an error.

  8. #8
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    20,961
    How about this (I'm just Googling, have never needed myself):

    http://answers.microsoft.com/en-us/o...c-fb5825f48539
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  9. #9
    Rawb is offline Expert
    Windows 7 64bit Access 2010 32bit
    Join Date
    Dec 2009
    Location
    Somewhere
    Posts
    875
    EDIT:
    I just tried the code from pbaldy's link above and works pretty well. You can't see what Records/Tables they're accessing, but it does seem to provide a close to real-time list of users in the database.

    If you want to use it with an ACCDB database though, you need to change the provider to Microsoft.ACE.OLEDB.12.0

    ORIGINAL POST:
    Quote Originally Posted by pbaldy View Post
    There are any number of ldb viewers out there....
    An LDB viewer won't be very useful as information can only be added to an LDB, not removed (as long as there is a user logged into the database). If there is always at least someone in the database all day, then users/computers will never be removed from the LDB even if they have logged out.

    For example: Alice logs into the database from ComputerA. Bob then logs in from ComputerB just before Alice logs out.

    If you look at the LDB file, it will still show Alice/ComputerA as being logged in. This is because Bob/ComputerB was logged in before Alice/ComputerA logged out, preventing Access from removing her information from the LDB file.

    I've run into situations where the LDB here at work will show one person as being logged in 2-3 times because of this. It also routinely shows people as being logged in when they haven't been using the database for several hours.

    The best way to see what users are logged in is to use a setup like June7 and Ajax described that manually tracks logins and logouts.

  10. #10
    cbende2's Avatar
    cbende2 is offline Competent Performer
    Windows 7 32bit Access 2013
    Join Date
    Jun 2014
    Location
    Louisiana
    Posts
    370
    Hmm after changing the provider to Microsoft.ACE.OLEDB.12.0 I'm still getting error:

    Invalid Outside procedure

    It then highlights Microsoft.ACE.OLEDB.12.0 in code

  11. #11
    Rawb is offline Expert
    Windows 7 64bit Access 2010 32bit
    Join Date
    Dec 2009
    Location
    Somewhere
    Posts
    875
    Here's the (slightly modified) code I'm using:

    In Access 2010, the Reference I needed to add was the Microsoft ActiveX Data Objects 2.1 Library

    Code:
    Sub ShowUserRosterMultipleUsers()
        Dim cn As New ADODB.Connection
        Dim cn2 As New ADODB.Connection
        Dim rs As New ADODB.Recordset
    
        Dim i As Long
        Dim j As Long
        Dim strDatabase As String
    
        strDatabase = "C:\Northwind.accdb"
    
        cn.Provider = "Microsoft.ACE.OLEDB.12.0"
        cn.Open "Data Source=" & strDatabase
    
        cn2.Provider = "Microsoft.ACE.OLEDB.12.0"
        cn2.Open "Data Source=" & strDatabase
    
        ' The user roster is exposed as a provider-specific schema rowset
        ' in the Jet 4 OLE DB provider.  You have to use a GUID to
        ' reference the schema, as provider-specific schemas are not
        ' listed in ADO's type library for schema rowsets
        Set rs = cn.OpenSchema(adSchemaProviderSpecific, , "{947bb102-5d43-11d1-bdbf-00c04fb92675}")
    
        'Output the list of all users in the current database.
        Debug.Print rs.Fields(0).Name, "", rs.Fields(1).Name, "", rs.Fields(2).Name, rs.Fields(3).Name
    
        Do While Not rs.EOF
            Debug.Print rs.Fields(0), rs.Fields(1), rs.Fields(2), rs.Fields(3)
            rs.MoveNext
        Loop
    End Sub
    Edit: I think the cn2 ADODB Connection is just to make sure there's another "user" logged in when you run the Sub. It doesn't look like it's actually used anywhere.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 3
    Last Post: 04-27-2015, 02:18 PM
  2. Using Access as a Resource Management Tool
    By Datech in forum Access
    Replies: 3
    Last Post: 05-21-2013, 01:17 PM
  3. Is Access the right tool for me?
    By buienxg in forum Access
    Replies: 1
    Last Post: 11-26-2011, 02:32 AM
  4. Is Access too big a tool for simple data?
    By chilly hellion in forum Access
    Replies: 3
    Last Post: 03-01-2011, 07:43 PM
  5. the search tool in access
    By Grooz13 in forum Access
    Replies: 1
    Last Post: 08-31-2010, 09:29 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Tech Forums: Microsoft Office Forums