This is only necessary when multiple users will be logging into PFIM simultaneously from the same PC in Access database environments – this is specifically designed for Terminal Servers where the PC name is the same for connecting clients and this causes issues with the locking file locking mechanism used by the Microsoft Jet database engine.

This can also be enabled where additional security to the PFIM access database is required via the operating system.

Enabling Workgroup Security alone does not prevent opening of the PFIM database through Microsoft Access. This would require implementing a password on the database Or removing / reassigning the Admin user.

It becomes critical that the WorkGroup database is backed up as well as the normal PFIM database.

At startup PFIM Checks the registry to see if workgroup security is enabled.
If it is then PFIM will create the workspace (and open the database) with the user name and password provided.
If not then PFIM will create the workspace (and open the database) with the default Admin user name and password.

To Enable Work Group Security
Log into PFIM – go to Setup -> Program Setup -> System Defaults And Options -> System Tab and tick on Enable per user database access.
Go to Setup -> User Access.
Create an Admin user and grant this user ALL Rights – the password MUST BE EMPTY!
Exit PFIM then log back into PFIM as user Admin and empty Password (“”).
Go to Setup -> User Access. Click Exit – You will be asked “Update PFIM Users to Workgroup System Database?” – when you click Yes – PFIM sets workgroup security enabled in the registry. – Creates the IAMWrkGrp.MDW file – this is the file that keeps track of users and groups.
Exit PFIM then log back in as the Admin user – now change the admin user password.
Exit user access and click Yes to “Update PFIM Users to Workgroup System Database?”. When prompted for the old Admin password leave the field blank and click OK.

From now on all user access needs to be done while logged into PFIM as the Admin user and you MUST answer Yes when asked “Update PFIM Users to Workgroup System Database?” otherwise the PFIM users and passwords will not be synchronised to the database / workgroup usernames and passwords and the users will not be able to log in.

NB!!
In each Terminal Session – log into the desktop as the Windows user. Run PFIM and log in as Admin. Go to Setup -> Program Setup -> System Defaults And Options -> System Tab and tick off then on Enable per user database access. (this sets the registry entry). Exit PFIM then log back into PFIM as user Admin.
Go to Setup -> User Access. Click Exit – You will be asked “Update PFIM Users to Workgroup System Database?” – when you click Yes – PFIM sets workgroup security enabled in the registry. – Creates the IAMWrkGrp.MDW file – this is the file that keeps track of users and groups.