At 08:42 PM 25/04/2007, you wrote:

>Hello Helen,
>
>the table has more than one record, but when the machine is running
>there's only one record updated all the time.

So...we have one single record in one table that is being updated
every second with a completely new set of data (many columns) and
committed. Are we talking about CommitRetaining here? Is this a
multi-user system or is the machine the only client? If there are
other clients, do they ever read or update that record? etc. etc.

Have you ever played the game "20 questions"?

./heLen