UnlockWorkStations

[apollonia]

when i attempted a recent update, an error was thrown (SetSqlMode choked on SET GLOBAL sql_mode=' ' ). I restored my original OpenDental program files and all worked fine, but still all the workstations were locked.

Is there a way to re-open access and unlock workstations, other than doing something like this?

Code: Select all

UPDATE preference SET ValueString = "" WHERE PrefName='UpdateInProgressOnComputerName'

[jordansparks]

Newer versions have a dialog that comes up that asks you if you want to override the lock for situations like this. But since you're using an older version, that query is the only option.