Requery while in transaction hangs app?

  • Thread starter Thread starter Derek Agar
  • Start date Start date
D

Derek Agar

Hello,
I have noticed w/Access 2002 that if i start a transaction and then
call requery on either a sub form or a combo box control, that it will
hang up access. I am using MDAC 2.8 against SQL Server 2000. The
form was opened unbound and I opened an ado recordset that I then set
the form's recordset to. I have an edit button on the form to enable
the controls and which starts an ado transaction. (I also have a
cancel button which disables the controls and rolls back the trans,
and a save button)
If I comment out the BeginTrans line, the requery works fine. I was
not able to find anything related to this doing a google search.
Anyone else notice something similar? Am I just not able to do a
requery while in a transaction?
Thanks
Derek
 
DA> I have noticed w/Access 2002 that if i start a
DA> transaction and then call requery on either a sub
DA> form or a combo box control, that it will hang up
DA> access. I am using MDAC 2.8 against SQL Server
DA> 2000. The form was opened unbound and I opened an
DA> ado recordset that I then set the form's recordset
DA> to.

You can only bind access objects to recordsets with client-based cursor;
hence, no transactions. Begintrans is for mdb's.

The way you described - creating ado recordsets and then twisting access'
arms to work with them - is not very productive because (1) you are re-doing
things already programmed in Access, and (2) there's a big probability of
incompatibilities like the one you just hit. You will achieve best results
if you provide Access with the datasources etc. and let it handle the data
by itself.

Vadim
 
Back
Top