Very Computer

>I'm trying to accomplish that myself, too. Did anybody come up with a nice
>way to do that ? Btw, you can trap for errors only when you try to edit or
>update a recordset. What if you want to test for locking when you open a
>recordset ?

>Luca

>> Other than trapping for errors is there a way to check if a record has
>been
>> locked ??

>> Regards,

>> Rob

>> Eruditio nimia cujus hoc legere potest.
>> (Translation - If you can read this you are over-educated)

> It depends on the DBMS you're using. ORACLE, for example, holds details of
> locks held on databse objects in a system table.

> Cheers,

> Mike

> >I'm trying to accomplish that myself, too. Did anybody come up with a
nice
> >way to do that ? Btw, you can trap for errors only when you try to edit
or
> >update a recordset. What if you want to test for locking when you open a
> >recordset ?

> >Luca

> >> Other than trapping for errors is there a way to check if a record has
> >been
> >> locked ??

> >> Regards,

> >> Rob

> >> Eruditio nimia cujus hoc legere potest.
> >> (Translation - If you can read this you are over-educated)