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
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
Has anyone else had a similar experience?
Many thanks,
D€$
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€$