>That said, there's still something weird going on. I omitted another complication in the original message because it didn't seem relevant here, but now I'm not so sure. The application is designed so that this table (and a couple of others) reuse older records. (Since this is an activity log, we don't need to keep the data forever. The customer chooses whether to reuse records, and if so, how long to keep each record.) Even with the new code that closes the table in one session, in the other session, I'm able to find a record old enough to reuse, but unable to lock it. That makes no sense since in my test scenario, there are only two sessions and the table is open only once in one of them. The attempt to add a new record (which is now working) doesn't happen until we fail to find a record old enough to reuse or fail to lock the record we find.
>
>Tamar
Tamar,
Just to be curious. What happens if you close / reopen your table and issue the Messagebox now?
Words are given to man to enable him to conceal his true feelings.
Charles Maurice de Talleyrand-Périgord
Weeks of programming can save you hours of planning.
OffThere is no place like [::1]