Auto FE Updater logo  Auto FE Updater

Home Basic Info Download About
Basic Info Wizard Update Config File Forms Enterprise Edition
Config File Comments
Server
Target Folder
Shortcuts
Shortcuts 2
Shortcut Icon
User Setup Email
User Setup Email 2
Start Method
Workgroup File
Command Line
Support Message
Trusted Location
Jet 4.0 Sndbx Mode
A2003 Security Level
Add server to local
FE Started by User?
Email Alerts
Uncompressed Files
Seldom Used
Seldom Used 2
Move Server/Folder

Update Configuration File - Workgroup File Settings

Settings - Workgroup File SettingsThe following MDW entries are required if you choose to use the Start Method set to Auto Select and your Access FE database file is using Access' User Level Security.    These are also required if you want to view the users in a secured backend Access database file.

Workgroup information file path and file name
This contains the path and name of the MDW file which you used to secure the Access front end MDB.  This should be kept on the server as suggest by fellow Access MVPs who know a lot more about Access user level security than I do.

Note that you may also need to pass the path and name of the MDW file to Access.  Thus you will want to have a Command Line option similar to
     /wrkgrp "\\server\share\My Access directory\security.mdw"
If there are any spaces in the folder path you will have to put double quotes around the path and file name.

Access user name
If you are only using the Start Method set to Auto Select then this user only needs the Open Exclusive permission on the database object.

If you want to view the users in a secured backend database file then the user specified needs Administer permissions on the database object.  This would usually be a member of the Admins group. 

Access user password
Note that when you click on the Encrypt Password command button or run this utility for the first time it will replace the password with the text "(Password is encrypted)" and create an MDWPasswordEncrypted entry in the configuration file.   Should you decide to change the password in the future replace "(Password is encrypted)" with your clear text password.  The utility will automatically update the MDW Password Encrypted setting to the new encrypted password. 

Remarks

Thank you to Joan Wild for clarifying much of the Workgroup file settings.   I've successfully avoided working with Workgroup files. :)

 

Wrench and gear Granite Fleet Manager - the best designed fleet maintenance tracking and management system available

Contact Search Site Map FAQ Tony's Main Microsoft Access Page Privacy Policy

Website copyright © 2001-2018 Tony Toews