Permission Issues when using Pass-Through Query

[TyFer]

Hello!

I need help with an issue. I have an Access database that is using SQL Server as the back end. I’m having issues with using the Pass-Through queries, but only when I’m calling a SQL stored procedure. When I just use SQL select statements, the users are able to view the information on the forms. It’s only when I’m calling a procedure that they get the attached error: "ODBC Call failed. Cannot find the object" The users click a command button and a form pops up that returns data from the stored procedure. I’m able to click the button with no issues. When the users click the button they get the permissions error. They have the correct permission on SQL Server. I've granted them execute permission to the stored procedures. The odd thing is, when the users open the actual form from the Forms menu, there is no issue and they are able to view the data.

I should mention, that the procedure returns all Purchase orders, however, the form only looks at a specific product, so there is a filter on the product id.

I’m not doing anything through VBA, just using the Pass-Through option on the Query Tools menu. So, I’m not sure why they can’t access this forms from the command button, but can access it from the Forms menu.

Any help is greatly appreciated.

Thanks!

Tyrella

 

[Galaxiom]

I’m not doing anything through VBA, just using the Pass-Through option on the Query Tools menu. So, I’m not sure why they can’t access this forms from the command button, but can access it from the Forms menu.

The PassThrough query is sent direct to the server. The server has no knowledge of Access objects at all.

 

[TyFer]

Thanks for the reply. I understand that, and all I have in my pass through query is the statement: exec proc_GetPurchaseOrders. The sever should recognize that. The user is able to open the form independent of the command button, not sure why there is an issue with the command button.