Results 1 to 3 of 3
  1. #1
    skydivetom is offline VIP
    Windows 8 Access 2010 64bit
    Join Date
    Feb 2019
    Posts
    1,038

    See/identify who's logged into "backend"

    Experts:

    I have a general question about the process which allows me to identify the computer name(s) of user(s) logged into my database (backend on server).



    Quick background:
    - I have a split database on my organization's network.
    - I previously tried a module that appeared to work fine on my home computer but ultimately didn't seem to work on the network.
    - Additional research allowed me to come across a single form example db (see attached zipped db).
    - Again, this example works fine at home (i.e., it display my computer name); I guess I will find out tomorrow (when at work) if it outputs names of multiple users while on the network.

    My questions:
    - This form includes a toggle command button "Disallow New Users"/"Allow New Users". How does the function work to disallow/allow new users?
    - Also, I'm using a process "Autoloader" which copies the frontend to the client machine's once I updated the version name on the server's frontend. That said, even as an administrator, I would bring up the "frmViewUsers" on my client's frontend (vs. server frontend). What's the impact on the form's Disallow/Allow toggle button? Will it still work?

    Thank you,
    EEH
    Attached Files Attached Files

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,824
    What dbms is backend?

    All I see function doing is changing caption on button and setting a connection property. Is it disconnecting/connecting to backend? Why do you have this code? What do you want to happen?

    If you want to know who is accessing backend, then possibly connection needs to be for the backend file, not CurrentProject which is the frontend. Try this in immediate window and see what path is returned:

    ?CurrentProject.Connection.Properties(7)

    I have code that when user opens frontend, it updates a record in Users table. When they close frontend, again updates record in Users record.
    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
    skydivetom is offline VIP
    Windows 8 Access 2010 64bit
    Join Date
    Feb 2019
    Posts
    1,038
    June -- thank you... I ultimately came across another which follows your recommendation. That is, DB entry and DB exit are appended to a table. It works like a charm.

    Thank you for the feedback!!

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

Similar Threads

  1. Replies: 7
    Last Post: 11-20-2019, 03:22 AM
  2. Replies: 1
    Last Post: 09-07-2015, 08:00 AM
  3. Replies: 8
    Last Post: 05-15-2015, 05:11 PM
  4. Replies: 1
    Last Post: 06-27-2014, 10:51 AM
  5. Identify "duplicated" rows
    By mkallover in forum Queries
    Replies: 7
    Last Post: 01-15-2013, 12:45 PM

Posting Permissions

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