ADO not updating MDB file

[custsoft]

We are using VB6 and ADO 2.1. We are using the ado recordset.update and then doing an ADO refresh. We then use a crystal report control to execute a crystal report that uses the mdb file. Mainly we do this before printing a payment receipt but it appears that the payment detail doesn't always print on the receipt but it is inconsistent. If we go back in to re-print the receipt it works. Is there a way to make sure the underlying database is updated consistently before printing the receipt. Thanks for you help. Joe.

 

[NipsMG]

Joe,

I've had some of the same problems before. For some reason, it seems that moving to the Next or Previous record and then BACK again after updating the recordset seems to help (if it's a bound recordset).

I have NO idea why, but this has worked for me numerous times.

Give that a shot, see if it works.

--Michael P. Gerety

 

[krkX]

Hi there,

I have the same problem, however if you close you ado connection then it seems to update the recordset in the mdb file. A bit lame but works for me..

krkX