Unanticipated Results when Executing a SQL stored procedure from Access 2010
Posted on 2013-12-02
I’ve created a pass-through query in Access which executes a stored procedure that searches for a string across all tables in my SQL database. The stored procedure on the SQL server runs as expected with results that show all the tables that contain the value in my search string. However, when I run that same SP using the pass-through query in Access, the Access “view” returns only one table instead of multiple tables that contain my value. I know the Access interface behaves differently than SQL, but I have a form which is bound to the search result of the pass-through query and I need the users to view all of the tables which contain their search string.