Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Arithmetic overflow error converting expression to date type datetime (#8115)

Status
Not open for further replies.

PWD

Technical User
Jul 12, 2002
823
GB
Good morning, I have an Access database that only seems to give me this error. If I copy the code out and run it in SQL Server I get the same error unless I prefix the code with
Code:
 set language british.

There doesn't appear to be any way of adding this to the Access query though. I can't see how any of my date/time settings are different from anyone elses.

Previously "my people" have told me it was a permissions thing but say that's not the case here.

It even gives the same error message when I just use
Code:
 SELECT pris_vwIAPT_ALL_Waits_optin.casenumber
FROM pris_vwIAPT_ALL_Waits_optin

Has anyone else had a similar experience?

Many thanks,
D€$
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top