Hello Experts:
I recently split a database into "backend" (BE) and "frontend" (FE) where the BE remains on the LAN and users have a local copy of the FE on the C-drive. The process works well.
At this time, I'd like to expand the FE to include a mechanism so that I (or administrator) can see which user(s) is/are currently logged into the BE. I've come across a ready-to-go solution which contains a single form. The example file "LoggedIn" (attached) did **not** include any special configuration or setup.... GREAT!
The database's single form includes four fields: Computer; Username; Connected?; Suspect?
When trying it at work (on LAN) and I opened up the database and the form displayed the following information, for example:
Desktop12345; Admin; True; (Blank)
Now, the computer name (some alpha-numeric number) in conjunction with "Admin" does **not** tell me anything about the user's name. So, I was wondering if you please could assist me in tweaking the form.
Break/break
In order to tweak the database, allow me to quickly jump into the method of existing database. For instance, my actual database includes a module "M02_UserName" (see "Module.accdb"). That is, the module uses the function fOSUserName() to determine the user's network name. So, any user logged into the LAN automatically is being picked up and shows, e.g., as "John Smith" or "Sally Jones". Having the user's name is much more helpful that the user's computer name.
That said, I'd like to use fOSUserName() function from the 2nd Access file and somehow integrate it into the "LoggedIn" example database so that I could show the following:
Desktop12345; John Smith; True; (Blank)
Desktop98765; Sally Jones; True; (Blank)
Is that possible? If so, how can achieve it? I appreciate any specific example which would facilitate the integration of the module into the form.
Thank you,
EEH