Running SP from Access 2000 with using SP owner qualifier

Hi there,

Can anyone tell me how to call a SQL Server Stored Procedure from an MS Access form with having to use the owner.spname style. I just want to call spname from my form.

I know it has to do with user permissions and roles, but no matter what I do I have to still use the owner.spname style.

Thanks,
Brian.are you using ADP?

if you're not, move it to ADP-- it is an awesome platform.

(ADP handles SP a lot better than MDB)|||Thanks for the suggestion Aaron, but I am using ADP and it's Access 2000.

I think the issue is on the server side with SQL Server, but one of the lads working (same privileges apparently) with me doesn't have this issue ... it's weird and greatly annoying.

Cheers ...|||instead of dealing with buggy input parameters i usually just use this syntax in the recordsource property of an ADP form or report:

EXEC sp_colums 'sysobjects'

is that what you're looking for?|||That works a treat Aaron, thanks a mill. Now life is just so much easier :)