Data error

[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?

 

[Brendan Reynolds]

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.

 

[Brendan Reynolds]

Darn that speelchucker! For 'required', read 'requeried'!

--
Brendan Reynolds (MVP)

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.

<snip>