I have a database with an Access FE and SQL Server BE. I am trying to insert data into an Access form and when I save I get the error below:
ODBC Call failed
Microsoft SQL Native Client 11.0 Datetime field overflow (#0)
The data I am entering still gets written to the table, but this error shows up everytime. How do I stop this happening?
I have used different drivers for the linked tables, the SQL Server data types for all the date fields are datetime. I don't know what else to try.
Appreciate any help!