No I don't want to do this, but have to for one specific purpose only! To load a table from a CREATE TABLE sql which has a Decimal data type I have to!
Good to see that you are reverting back immediately. Years ago I changed it and forgot to swop back. Lots of issues that I couldn’t pin down as I couldn’t remember what I’d changed
One of the recent bugs in Access, which was recently fixed, was paralleled, it turns out, when ANSI 92 was turned on. Tracking that down was, like Colin said, not easy. I'm surprised that there is actually a use case for it.
This article discusses the unhelpful reserved error messages that you may occasionally see. The meaning is explained for several of these errors together with action you can take to help eliminate these in the future.
isladogs.co.uk
There may be other such examples
As for use cases, perhaps it was useful back in the far distant days of Access Data Projects (ADP) which allowed direct connection to SQL Server but were deprecated in A2007
This article discusses the unhelpful reserved error messages that you may occasionally see. The meaning is explained for several of these errors together with action you can take to help eliminate these in the future.
isladogs.co.uk
There may be other such examples
As for use cases, perhaps it was useful back in the far distant days of Access Data Projects (ADP) which allowed direct connection to SQL Server but were deprecated in A2007