A pass-through delete query that i was using in windows xp pro, office access 2003 is not working in windows 7, 2010. In windows 7, office 2010 I created the same DSN ODBC Connections that I had in 2003. I re-linked the tables and they all
work fine. However, When i open the pass-through query in design mode and click "run" in 2010 the "Select Data Source" window opens. I select the DSN, enter the SQL Server Login password and get the message "Pass-through query with ReturnsRecords
property set to True did not return any records." Can someone assist me with getting this working in windows 7, office access 2010. Thank you.
The answer to your issue is directly in the message. Open your pass-thru query in design view and then select "Property Sheet". You will see a property named "Returns Records" this property defaults to YES - chenge it to NO and your error should disappear.
Mark Burns, MCAD, MCP
Sr. Microsoft Access Analyst/Developer
Manager LinkedIn.Com community: Professional Microsoft Access Developers Network (PMADN)
Marked as answer byBruce SongMonday, March 21, 2011 6:21 AM