Refresh

  • Thread starter Thread starter Wortelvisje
  • Start date Start date
W

Wortelvisje

Hello,

I'm using ado.net in my newest project, but their is a little strange thing
going on. In form1 I'm having a list of record, by a button a change
something in form2 (in fact, its a different data adapter, on a different
connection object). But the changes only appear after 2 refreshes (2 times
requery and refill of the dataset, on a Acces DB).

Is their a better way to do this? even 2 times requery doesn't work on every
part of the program.

Somebody?

greets
Nelis
 
If I understand you correctly, this behavior is characteristic of JET/access
databases. Changes are not posted to the database immediately, but only when
the engine is idle or you have forced the write to take place.

--
____________________________________
Bill Vaughn
MVP, hRD
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
 
how can I force it?

William (Bill) Vaughn said:
If I understand you correctly, this behavior is characteristic of JET/access
databases. Changes are not posted to the database immediately, but only when
the engine is idle or you have forced the write to take place.

--
____________________________________
Bill Vaughn
MVP, hRD
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
 
As many have pointed out, I'm no JET fan or expert but I understand that one
method is to use Transactions. My suggestion would be to switch to MSDE
which does not have this (or many other) JET problem(s), but I know that's
not always possible.

--
____________________________________
Bill Vaughn
MVP, hRD
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
 
Back
Top