I have a backend SQL Server and an Access adp front end.
I have created a new user and gave it the dbo role.
When I login with the new user, the stored procedures running on the form can't be found. For example I have a couple of list boxes where their row source is set to a stored procedure.
How ever when I go under the list box and change the record source from (for example) SP_PersonList to dbo.PersonList it works fine.
I'm new to SQL and a little confused about roles.
If my user has the dbo role why do I need to call the stored procedures using the dbo. naming?
and now, should I go over all my forms and change the all the SPs to dbo.sp or is there any other way to fix this?