Sorry, that last message got garbled:
> -----Original Message-----
> From: CHIUSANO, Joseph [mailto:]
>
>
> It seems reasonable to assume that when committing this
> information to a
> database, one may have to lock multiple tables simultaneously (thereby
> violating the best practice rule of "hold locks for as little time as
> possible"). That is, the Order table would need to be
> locked, then the Item
> table (while the Order table is locked), etc.
Why the assumption of table-level locking? Neither do I see how the
structure of the XML document matters, assuming you have a
database that
supports optimistic concurrency and atomic transaction commitment.
However, if you're using MS-Access in a multiuser
environment, there's no
hope for you anyway. :-)
