Hi Daniel

>
> An open query(no insert, no update, no delete) is enough to stop the
> OAT from advancing, since it uses a transaction as well. And, if you
> use the same transaction to insert, update and/or delete, then you can
> see why the OAT might not be advancing.

I thought there where mechanisms in IBO for tackling this but I will
investigate.

>
> >>
>
> OAT problems can be produced with other connection solutions(other
> than IBO), if the transactions are not handled properly(i.e.
> transactions that are active for a long time).
>

I only have IBO and some old BDE. The BDE stuff hasn't been touched for
ages and the problem is fairly recent.

Thanks for the reply

Regards
Paul