SQLTeam.com | Weblogs | Forums

MS Access Datetime field overflow error

access
sql2014

#1

Hi all,
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!


#2

What is the range for access for datetime, is it possible the date is valid in access but not in sql server like before 1753?


#3

Thanks for the comment. I realised later that the data types were not set correctly so your suggestion is actually the answer. Thank you!