Update queries with form (trying to avoid error)

  • Thread starter Thread starter Mark Andrews
  • Start date Start date
M

Mark Andrews

I have an access2007 application that has three forms
1. Form1 is a continuous form used to list some records (each record has an
edit button)
If user presses the edit button Form2 popups up
2. Form2 is a continuous form used to list other records (each record has an
edit button)
If user presses the edit button Form3 popups up
3. Form 3 has a variety of controls, when the user presses the OK button I
would like to run
some update queries that affects records in Form1 and Form2.

I sometimes run into an error:
"Could not update currently locked by another session on this machine"

I'm assuming the records sometimes get locked by Access because they are
open by form1 and form2.
Even though form1 and form2 do not allow edits to data directly, but they
are bound.

I want to keep using code to run update queries, is there anyway to get
around this situation?

Thanks,
Mark
 
I think I'll try manipulating the recordset clone of the open forms (instead
of running update sql).

No need for help,
Mark
 
Back
Top