This is the 2nd question on this subject that I have had to ask in the last 2 months. The last time I found my own solution and posted it here on Experts-Exchange for all to benefit. Here is the link:
It looks like I have run out of steam on finding an answer to this one. By going to the link I posted in my last question I found these instructions on how to edit the Windows Registry to keep my query from being blocked by Microsoft's new security constraints. Here is the link:
The instructions I preformed at this link did not fix my problem. I still get the error message in the attached screen shot.
The difference between this time and last is that last time I was working in the MS-Access IDE; i.e., the MS-Access that comes with MS Office 2007 Professional edition. Now I am trying to accomplish the same thing except here I am using the free MS-Access 2007 Runtime that is downloadable from the Microsoft support website.
I found 2 questions answered here on EE that lead me to believe that there is a solution for my problem that works. Here are the links to both of them:
In both of these questions I don't believe an ODBC data adapter was being used. I need the ODBC data adapter because it is the only way that I know of to use the Reporting capabilities of MS-Access on a MySQL database. This ODBC data adapter is being used in a ODBC Data Source Name on another machine with the full MS-Access 2007 environment and works just fine. One of the reports that works just fine uses a Pass Through UNION Query which I need because MS-Access 2007 strips out my column aliases without it. On the machine that I am having a problem there is a previous version of my report package written in MS-Access 2002 that uses the same ODBC Data Source Name (DSN) without a problem. So the ODBC DSN should not be a problem. I have the ODBC DSN configured the same on all machines which will be using my report package except on the development machine the network connection is to localhost and on the test machine the network connection is the host name of my development machine so that the test machines will be looking at the same database as the development machine is looking at.
Attached is a screen shot of my Windows Registry editor with one of the changes recomended in one of the EE questions linked to above. Maybe I am editing my Windows Registry wrong?
Thank you for any help you can give me.