A.D.Tejpal
adtp at airtelmail.in
Sat Aug 8 07:16:20 CDT 2009
You are most welcome Max! It is an interesting topic and various implications have to be kept in view.
Thanks for your comments.
Best wishes,
A.D. Tejpal
------------
----- Original Message -----
From: Max Wanadoo
To: 'Access Developers discussion and problem solving'
Sent: Saturday, August 08, 2009 15:46
Subject: Re: [AccessD] OpenRecordSet question
Very interesting AD.
>>
Any two instances of CurrentDb retrieved are not automatically in synch or
transparent to each other. The situation could be considered akin to two
different recordsets for the same data source.
<<
This is exactly what I would want and expect in most cases. I would not
want a second instance to have any bearing whatsoever on the first and I
would want/expect to close the second down without any effect on the first.
Good summary - many thanks
Max