I have an adp and use the DoCmd.OutputTo macro to output a stored procedure into an excel workbook.
The problem I am having with it is that there doesn't seem to be a way to specify the owner of the stored procedure object which I need to do since the owner is not a DBO but is actually my username.
It works fine on my PC since SQL Server uses my username to find the stored procedure but for the other users it throws the invalid object name because it is neither a dbo object nor are they the owners. It seems that both through VBA code and the macro interface in Access that it doesn't let me input the owner in the format of "[Server\myusername].StoredProcedureName" which would be needed for everyone else to be able to access this stored procedure that I have created.
Anybody know how to get around this without creating the stored procedure as a dbo object.