Due to circumstances that are not completely under my control, I have to develop ACCESS requests that will be stored in Access 2000 MDB, but which can be developed under any of the following: Access 2000, 2002, 2003, 2007, 2010. These requests will be access (via linked tables) either an MS SQL Server database or an Access 2000.MDB file.
In the past, we had issues that we tracked for queries that were not compatible with ANSI-92. We decided this by checking the box on the Tables / Queries tab of the Tools | Options dialog box (in older versions of Access than in 2007).
We move these Access.MDB applications between different systems, and now we usually have no problems.
However, I just developed a request that works fine with all internal connections, but when I change one of the connections to an external connection, the request fails with the "Invalid operation" error in Access 2010. So I thought I would check if it is installed ANSI-92 flag I could not find him.
Now I KNOW that Access 2003 and later versions use the ANSI 92 syntax automatically, but I wondered if there is a way to verify that this applies to these requests in this (rather specific circumstances). I noticed that when we changed the checkbox, all my “Like” queries became “ALike” queries ...
So the question boils down to the fact that the syntax of ANSI 92 is completely transparent in these circumstances and the reason my request fails is something else ...
TIA, Paolo