Thanks Helen.
In fact these tables are in a database local to each workstation. So
there is only a single user for each.
Dave

--- In IBObjects@y..., Helen Borrie <helebor@d...> wrote:
> Neither of those options is a good idea. What happens if User A
wants to drop or empty the table when User B is using it?
>
> The best plan is to simply add rows to your table and mark them
somehow to identify them to a particular user/session. You can
probably log the primary keys of rows to another table when the rows
are no longer required, using a trigger, and have some kind of a
service that does housekeeping on this temporary storage periodically.
>
> regards,
> Helen
>
> All for Open and Open for All
> InterBase Developer Initiative · http://www.interbase2000.org
> _______________________________________________________