This question evolved from one of my earlier postings and remains unsolved. I am posting this single question in order to give it focus.
The question is: How can I change from ANSI 92 to ANSI 89. I am using the Office 365 version of Access.
I have tried going into SQL server compatible syntax (ANSI 92) and unchecking the two boxes, and then pressing "OK".
This does not change the default ANSI setting.
This is the case whether I am using a DB in the mdb format or in the accdb format.