Microsoft Access An Admin Db Part 1

Count Users of Other Databases With the Jet User Roster
An administrative database can help you keep track of the other Access databases you are responsible for. The Jet User Roster can tell you who is logged into an Access database.
In this video we will:
1. Discuss the pros and cons of using the Jet User Roster
2. Build a table and form to store which databases to track
3. Build a form and table to count users of other Access databases
The VBA in this video can be found here:
accessjitsu.com...
Video covering the Office Open File Dialog:
• Using the Microsoft Of...
All of my videos organized by topic and other blog topics:
accessjitsu.com/

[@wildmagic520]

Your series are very instructive and fits my department's need to to monitor databases, prevent new logins and force out users when performing maintenance tasks. Was able to code my own database management program to handle the tasks 1 & 3. Really appreciate your insights and methodical thinking of how to put one together. My goal is to have these features: 1) Inventory new databases and have learned to create "hyperlinks" that allow the user to specifiy where (directory path) the database, the user guide and program logic or workflow are located and to open these from one central database 2) view users in these databases 3) force users out to allow maintenance 4) update global constants table that some of our database have in common and even update their local temp table from linked SQL Server tables and stored procedures Just wondering if you wouldn't mind providing database samples that already have the forms and code from your articles. Again, thank you for taking the time to create these series and all of your other instructive videos and articles teaching how to fish in Access.

[@kerrydoolgar9079]

Excellent!!!

[@blesses363]

Hi - I have fontend form on shared network, I wanted to create a table where I can manage users with their domain name and yes/no check box, I want in frontend_form in every 30 minutes to check from backend, if user domain and check box checked (yes) then allow users to use the frontend else close the form