dr_john_mp,

d> I have a number of users who tend to leave an application open on the
d> desktop with one/more open queries displaying data in a dbgrid.

Switch to a disconnected architecture, in which you hold transactions
open only for the time it takes to a) fetch the data and b) send the
changes back to the database, and your problems will go away.

From your post I assume you are working with Delphi: there's plenty of
solutions there for disconnected architectures, both out-of-the-box
(like DataSnap and dbGo) and from third parties.

HTH
--
Nando Dessena
======================================================
I support Firebird, I am a Firebird Foundation member!
Join today at http://www.firebirdsql.org/ff/foundation
======================================================