Re: Best Multi-user strategy for ADO on an Access (mdb) file

From: Brian Bushay TeamB (BBushay_at_Nmpls.com)
Date: 08/14/04 

Date: Fri, 13 Aug 2004 18:04:58 -0500

>OK, so an approach to multi-user situation is to use batchoptimistic and
>update criteria to raise exceptions when user edits "clash". Message
>received, and yes I have been transaction obsessed.
>
>With master/details use identity fields as key. Yes the master has to be
>posted (and key set) before the details can be created for referential
>integrity.
If you use BatchOptomisic an Identity field doesn't get a value until you
UpdateBatch so the combination of Identity fields as linking values isn't going
to work if you try to have the master and detail records in the same batch. 

--
Brian Bushay (TeamB)
Bbushay@NMPLS.com