Full Version: Display Users In Database On Form/switchboard
UtterAccess Forums > Microsoft® Access > Access Forms
kevnaples
I have a main switchboard which has a password protected macro button which sends a summary report via email to management twice daily. On several occasions the users have voiced concerns over long spooling times (over one hour) to build the report. Since this database is used by upwards of 15 users (they do not have to log in) is there a way to display how many members are in the database? They are all supposed to exit the database during 0615-0630 & 1815-1830 hours daily so the lead officer can send the summary report. They have no way of knowing how many users are in the database and what records they have open (I am thinking this may be delaying the report). If I could display the count of users on the main switchboard It could serve as a flag for the lead officer to get members out or to restrict the summary report macro from running if the count is over 1.
Thanks in advance for any help.
Kevin
DanielPineault
There are ways to determine who is in a database, but it has to do with your setup. For more information, see:
http://support.microsoft.com/kb/285822
http://www.access-programmers.co.UK/forums...ead.php?t=28575
http://access.mvps.org/access/general/gen0034.htm
oreover, I fail to see why people need to logout to enable so the lead officer can send the summary report?!
Is your database split?
Does each user have their own copy of the front-end?
If so, then there should be no need to kick people out to generate reports!
With regards to performance, take a look at:
www.granite.ab.ca/access/performancefaq.htm
http://www.fmsinc.com/microsoftaccess/performance.html
Make sure your db is split, each user has their own copy of the front-end and ensure you have a persistent connection to the back-end!
This is a "lo-fi" version of UA. To view the full version with more information, formatting and images, please click here.