Page 1 of 1

UnlockWorkStations

Posted: Sun Mar 21, 2010 5:37 pm
by 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'

Re: UnlockWorkStations

Posted: Sun Mar 21, 2010 10:13 pm
by 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.