ODBC--call failed error Access 2016/SQL
Hi
I am having an issue with Access 2016. When users try to save when they first input details into the emergency contact tab they receive an ODBC call failed error (screen shot attached). This database has an SQL 2008 R2 back end and I have checked the SQL table and the Surname exists in ServiceUsers so the value is not null.
If a user closes the tab by using the x button in the top right hand corner the details do save to the table. Is there a way to prevent this error occurring?
Any help would be gratefully received
thanks
H--alpha.JPG
I am having an issue with Access 2016. When users try to save when they first input details into the emergency contact tab they receive an ODBC call failed error (screen shot attached). This database has an SQL 2008 R2 back end and I have checked the SQL table and the Surname exists in ServiceUsers so the value is not null.
If a user closes the tab by using the x button in the top right hand corner the details do save to the table. Is there a way to prevent this error occurring?
Any help would be gratefully received
thanks
H--alpha.JPG
Vitor Montalvão
As the error says you're trying to insert a NULL value in a field named Surname that requires a values (can't be empty). So tell the user to provide a surname so he or she don't receive the error anymore.
<<So tell the user to provide a surname so he or she don't receive the error anymore.>>
or allow nulls in the field.
Jim.
or allow nulls in the field.
Jim.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
One important point:
<<If a user closes the tab >>
If your using a main form with subforms, be aware that Access saves the main form record as soon as you enter a subform.
So if they have not filled in the surname on the main form, then try to enter emergency contact details by clicking into a subform, you'd get the error.
Is that the setup you have or something else?
Jim.
<<If a user closes the tab >>
If your using a main form with subforms, be aware that Access saves the main form record as soon as you enter a subform.
So if they have not filled in the surname on the main form, then try to enter emergency contact details by clicking into a subform, you'd get the error.
Is that the setup you have or something else?
Jim.
ASKER
Many thanks for your help, I have managed to amend the permission on the surname while keeping the validation that I requrie