Re: Which Object to use for Tansaction process
- From: "Graham R Seach" <gseach@xxxxxxxxxxxxxxxxxxxxxx>
- Date: Mon, 11 Jul 2005 21:49:31 +1000
Roshan,
The only way to use a single object to wrap the transactions is if you use
DAO or ADO exclusively. Even then, if you use DAO, you have to use the same
workspace for all transactions. Similarly, if you use ADO, you have to use
the same connection for all transactions.
My advice is to choose one or the other. If you're operating solely on Jet,
then use DAO, otherwise use ADO.
In any case, there's nothing wrong with using two objects, provided you keep
them synchronised.
Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
---------------------------
"Roshan Abbasi via AccessMonster.com" <forum@xxxxxxxxxxxxxxxxx> wrote in
message news:511BD4D93D5E0@xxxxxxxxxxxxxxxxxxxx
> Thanks Graham for the response. But, my actual confusion still persists.
> I am wondering, is there any solution for the situation, depicted in my
> Xmple
> procedure, that is, one Transaction process nesting all the function
> calls,
> which use two different types of recordsets.
>
>
> --
> Message posted via AccessMonster.com
> http://www.accessmonster.com/Uwe/Forums.aspx/access-forms/200507/1
.
- References:
- Which Object to use for Tansaction process
- From: Roshan Abbasi via AccessMonster.com
- Re: Which Object to use for Tansaction process
- From: Graham R Seach
- Re: Which Object to use for Tansaction process
- From: Roshan Abbasi via AccessMonster.com
- Which Object to use for Tansaction process
- Prev by Date: Re: Help with placing data in other text boxes from a dropdown list.
- Next by Date: Re: Color in a tex field
- Previous by thread: Re: Which Object to use for Tansaction process
- Next by thread: Re: How do I find a blank pedigree certificate?
- Index(es):
Relevant Pages
|
