Master Form

[mjdemaris]

Has anyone had success creating a master form that shows you who is connected to what database, allow you to send a message to users, kick users...?

I have seen a picture of one posted a while back, but no details were given on how to do it.

I will have my second database online in a couple of months, and a few more to come.

All of these are in Access, of course.

Mike

 

[NauticalGent]

Try this:

http://www.databasejournal.com/feat...8586/Auto-Logout-Users-for-DB-Maintenance.htm

I prefer some code by Andrew Couch in his book "Access 2010 VBA Programming - Inside and Out".

With his code, each object that is opened gets saved and closed individually before quitting Access.

Good luck!

 

[mjdemaris]

Here is a link to a previous thread, but I think the owner is no longer active.

http://http//www.access-programmers.co.uk/forums/showthread.php?p=948955

 

[mjdemaris]

After doing some reading, "Microsoft Access 2013, Programming By Example", Julitta Korol, and some research here, I believe the way to set up an Admin Panel would be to use a logging table in each database and connect to them using DAO or ADO, not sure which is better, yet. Then I could retrieve the data of who's on. I could also use a form to send a message - as the link you provided, Nautical, describes.

By the way, do you sail?

 

[NauticalGent]

Great plan! As you have deduced, there are many ways to do something. The best approach is to take what you need from different sources and make a solution that fits your needs.

Glad you are making your way...

I am retired from the US Navy, but have been known to cut a jib once and again...how about yourself?

 

[mjdemaris]

I would love to get out on the water again. Went fishing in the southern Alaskan Islands, had a great time. Currently, just a maintenance guy who spends most the time at work developing Access databases.

It get boring sitting in this chair for so long, lol. I hope to move on to another company or freelance after I get a bit more experience.