Data error

  • Thread starter Thread starter Peter
  • Start date Start date
P

Peter

My Access 2000 mdb database generates occasional data
errors. These seem to be associated with running an
action query that affects the underlying tables while a
form that uses those tables is open. When I requery the
form a data error is generated.

The error is normally trapped in the Form_Error event and
I can use the acDataErrContinue response to suppress the
message. However if I make an mde file of my database
and run that, the error is not always trapped in the
Form_Error event and an error message is shown on the
screen.

Any idea what might be causing the mde file not to trap
all these errors?
 
AFAIK, having the form open should not be a problem *provided* any changes
made via the form are saved before the query is executed, and the form is
required afterward. Try a 'Me.Dirty = False' before executing the query, and
a 'Me.Requery' after executing the query.
 
Darn that speelchucker! For 'required', read 'requeried'! :-)

--
Brendan Reynolds (MVP)

Brendan Reynolds said:
AFAIK, having the form open should not be a problem *provided* any changes
made via the form are saved before the query is executed, and the form is
required afterward.
Click to expand...
<snip>
 
Back
Top