CEMT Best Practices

The CEMT is designed to be a central hub for managing separate Open Dental databases. In an ideal situation:

Use the CEMT

  1. Create and use one CEMT database for all CEMT users.
  2. Create a CEMT user for each person who will use the CEMT and assign them security permissions. These permissions will restrict or grant access to certain areas of Open Dental databases (just like other Open Dental users).
  3. Create a connection for each Open Dental database the CEMT will manage.
  4. Refresh Connection on each connection, then Sync all security settings to all Open Dental databases.
  5. Have the user log into the CEMT using their CEMT username and password.
  6. The User can double click a connection to launch Open Dental and connect to the Open Dental databases. Logging on to the Open Dental database will be automatic with the permissions set in the CEMT.
  7. Manage all CEMT users in the CEMT only and sync to all Open Dental database after any change. This will avoid any concurrency issues.

There is no reason to use multiple CEMT databases. As of version 16.2, it is not allowed. Multiple CEMT databases only creates additional work for users and complicates syncing of users and security settings. All security changes in one CEMT database would need to be synced to all other CEMT databases and all Open Dental databases for all databases to remain accessible. Otherwise you could face some of these challenges:

Other concurrency issues may also occur.