MYOBDC - MS Access - Update errors - have to restart

[redwhip]

Hi,

I have an Access application which is linked to MYSQL using MYODBC.

Whenever a user tries to update a column which they don't have permission for they get an error and are then forced by Access to shutdown the form completely. They then lose all that they have already inputted in the other fields.

Is there any way that it can give a custom error message and let the user carry on updating the form they have been working on?

Regards
Skink

 

[genomon]

Do you know the error number? If so you can trap it with an error handler:

On Error GoTo ODBCError

etc.....

ODBCError:
If Err.Number = 999(whatever it is) Then
Msgbox "You have an error......"
Resume Next
End If



The Microsoft mascot is a butterfly.
A butterfly is a bug.
Think about it....

 

[PRPhx]

How does the user update a column? Thru a textbox, drop down, combo box, etc? Why not disable that textbox, etc. so that they can't touch it in the first place. Also set the textbox, etc up so that it is NOT a tab stop