Update in DB but not in SELECT

  • Thread starter Thread starter Stephen Plotnick
  • Start date Start date
S

Stephen Plotnick

I do an UPDATE with SQL using OLEDB and when I try to go back to the Select
statement it does not find the updated field. If I try SELECT a second time
they are there.

I did look at the actual Access DB and the field is updated properly after
the UPDATE statement.

Steve
 
I do an UPDATE with SQL using OLEDB and when I try to go back to the Select
statement it does not find the updated field. If I try SELECT a second time
they are there.
Click to expand...

These things usually happen if one connection is used for writing and
yet another
one for reading. Use same connection for both UPDATE and SELECT.
 
Back
Top