At 10:47 PM 18/01/2007, Nando Dessena wrote:

>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.

This technique is also known as "throwing the baby out with the bathwater".

./heLen