Auto FE Updater

Enterprise Edition - FAQ

Other FAQs - Regular FAQ and Licensing FAQ

Q: I can't see any connections in the View users in backend database files screen but I know there are lots of users in the SQL Server database.
The DBA or IT admins must give you explicit permissions to view this data by issuing the following SQL Server command.
GRANT VIEW SERVER STATE TO <your network userid>

Q: I can't see all the users on a Terminal Server in the View users in backend database files in the Access backend.   
The Access LDB/LACCDB only records the workstation name.   The only way to determine the name of the user is to query the log database file for the last user of that workstation.  This, of course, doesn't work for Terminal Server users.   You need to implement the AutoFEUpdater_ExitApp code as found in the Auto FE Updater Sample Code Vx.xx.mdb in the distribution zip file.   

Q: Why is the View Log button on the main form sometimes red?
That's an indicator there are unacknowledged errors or warnings in the log database.  Some warnings don't generate alert emails as they are not important enough but they should still be logged.   This is checked every 60 seconds by a SQL query to the AutoFEUpdater Log.mdb file and when StartMDB.exe or the List of Config Files form receives the focus.

Does the AutoFEUpdater Log.mdb stay in the folder where StartMDB.exe is located, or does it go in the folder with the database BE?
If the users have read/write permissions to the folder where StartMDB.exe lives then you can put the AutoFEUpdater Log.mdb in that folder.     Otherwise if you only have one application which uses the the Auto FE Updater then you can put the AutoFEUpdater Log.mdb file in that folder.   However, if you have more than one application  the AutoFEUpdater Log.mdb should reside in a folder to which all the possible users read/write/create/delete permissions.

The AutoFEUpdater Log.mdb is designed to be shared among multiple Auto FE Updater configuration files. 

Does the AutoFEUpdater Log FE.mde get put in the same folder as the database FE as a file that gets uploaded to the user's computer?
No, the FE.mde file is only for the developers or the IT administrators to use.  There is no need for the users to get the FE.MDE.   I will be putting in a method of having the FE MDE automatically downloaded to your Application Data folder but that's not quite ready yet.

One individual left an Access application running when they went home for the day.  I can see them on the Lock screen but I can't do add the fields I wanted to and do the compact.
Use the tips and code at Idle Detect/Inactivity Timeout to force users out after 30 minutes of inactivity.  At some point in the future I will be creating some code which can be placed in a hidden form which will check for the lockout status in the configuration files. This code will be added to the 'Auto FE Updater Sample Code V1.,xx.mdb' which you can import into your application.