I am trying to determine the best way to handle database owner (dbo) when developing my application. I did the development using "sa" as the dbo and Access lets me get by without using dbo as part of my table and stored procedure calls. When logging in as a different user, Access tells me it can't find the stored procedure. If I add dbo. to the front of the stored procedure it finds okay. Do I always need to add dbo. to data sources that are stored procedures. Also, anytime I call a stored procedure must it be prefixed with the dbo., such as, dbo.sp_GetRates instead of just sp_GetRates, which Access allows when developing under "sa".
What is the best way to handle the "dbo" when developing in Access 2000.
Thank you,
Jerry
What is the best way to handle the "dbo" when developing in Access 2000.
Thank you,
Jerry