I set up a stored procedure in an pass through Access query. It was working perfectly with QuickBooks Enterprise Solutions v8 and QODBC v8. We would run this query from the switchboard by clicking on a label that was hyperlinked to the query.
We upgraded to QuickBooks Enterprise Solutions v9 and QODBC v9 and the query started having problems. We can run the query without any problems if we click on the query itself. However, if we click on the hyperlinked label then the query runs and we get the following informational warning, "Microsoft Office Access can't follow the hyperlink to 'Query qrySP_Sync_Customer_Data'. Please verify the destination."
The SQL for qrySP_Sync_Customer_Data is sp_optimizefullsync Customer. The Hyperlink Address for the label is blank and the Hyperlink SubAddress is Query qrySP_Sync_Customer_Data.
If I change the hyperlink target to another pass through query that does not use a stored procedure then clicking on the label runs the query without the warning.
I uninstalled the QODBC driver and reinstalled it. I got the same results.
Do you know why I am getting the warning for the stored procedure when we click on the hyperlinked label?
Thank you in advance for your help.
Will |