Update query sometimes failed

[FuzMic]

Hi members

I have a FormA with record source from a TableA link to another. On clicking a command button, the codes update the changes in the form to TableA. Continuing on the codes then issue an UpDate Query to update some fields on the same TableA.

For some unknown reasons, the update fail at times, not frequent though. All this happen in a multi-user environment wherein Users can be opening various instance of FormA each on different record i presume.

Any insight to this; I hope.

 

[tehNellie]

Knowing what error messages people are getting would be useful in this context. An Update query can fail for all sorts of reasons.

You might have locking issues, your users might be making mistakes that the application code doesn't handle, the query might be wrong etc etc etc.

 

[FuzMic]

Thanks Teh

There is no message or at least staff did not report. I rule out Query failing because it not happening all the time. I would think that particular record that the process try to update may be used by another user.

Q: Is there a response when a Query Update failed, if so how do i catch it.

 

[tehNellie]

How is your Update query running? i.e. do users manually run the query? is there a button that they click on from a form?

If there is code on a button it might be surpressing error messages, what happens if you run the query and manually enter those values or even just turn off the error handling that is present in the query.

 

[FuzMic]

Teh

A button accepts the record changes followed by codes to update another table based on what is changed. It is not a direct running of the update query.

This update query has no problem at all when run separately. Hence i presume that failure is due to opened record conflict in an multi-user environment. What i am looking for is a break in the codes when the update query fails prompting a message.