Assuring that update by "database.EXECUTE sqlQuery " was done

  • Thread starter Thread starter Amiran
  • Start date Start date
A

Amiran

Hello

I'm doing some Excel<=> Access connectivity with VBA using DAO.

I display some table's contents on a sheet, and also I place some buttons
with macros to delete/modify those records.
Such macro ends with "myDatabase.Execute SQLQuery" where sqlquery can be
insert, update, or delete.

Then, after macro sends the query, I want sheet to refresh it's data to show
this recent update. Unfortunately sometimes it doesn't, because (I guess) it
asks Acess for data before those updates are applied. When I force the macro
to finish after 1 sec delay, the refresh catches this update.

Of course it's extremely unelegant, also I still cannnot be sure if 1 sec.
is enough, when DB gets bigger, so...

what is the proper way of doing this? How can I check if SQL action query
has been processed?

thanks a lot
 
Amiran said:
Hello

I'm doing some Excel<=> Access connectivity with VBA using DAO.

I display some table's contents on a sheet, and also I place some
buttons with macros to delete/modify those records.
Such macro ends with "myDatabase.Execute SQLQuery" where sqlquery can
be insert, update, or delete.

Then, after macro sends the query, I want sheet to refresh it's data
to show this recent update. Unfortunately sometimes it doesn't,
because (I guess) it asks Acess for data before those updates are
applied. When I force the macro to finish after 1 sec delay, the
refresh catches this update.

Of course it's extremely unelegant, also I still cannnot be sure if 1
sec. is enough, when DB gets bigger, so...

what is the proper way of doing this? How can I check if SQL action
query has been processed?
Click to expand...

If it's a timing issue, you may want to try using

DBEngine.Idle dbRefreshCache
 
Back
Top