Microsoft Access An Admin Db Part 1

[@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.

[@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

[@kerrydoolgar9079]

Excellent!!!