Asynchronous access problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form that queries a SQL database and updates an Access table through
a form. This procedure is run on demand. Part of the process involves
clearing out the existing data first. This is where I run into a problem.
In my code, I run an update query to clear out the data in the table that my
form is attached to. Apparently, Access continues on to query SQL Server and
starts to edit the data, generating a 3197 error: jet database engine
stopped...you and (another user) are attempting to change the same data at
the same time.

I realize that my code does not track my background query. How can I get my
procedure to detect it? Or if not, what is another way to clear all data from
a specific column in a bound form, through code?

Thanks in advance!

George
 
Ah, I figured something out.
I inserted docmd.requery "dataform_SUB" after the update query and before
the sql query and it now works just fine. So, requerying the datasource of
the subform did the trick.
 
Back
Top