Problem with dbo access, please help.

[indraT]

Hi There, I converted access database to sql with adp file for the front end. many of our query was not working so i had to rewrite it and its come with dbo.table name etc. Now when i did everything and try to distribute the adp file to our users many of its function not working because those user are not dbo or not have db owner access. I am at the end of the project but just realize that i may have lot of more problem. could any own let me know how i can solve this really big problem right now for me. running out of time.

Please help.

Thanks
Indra.

 

[cmmrfrds]

If the tables, SP's, views, etc.. are prefixed with dbo. in the app then the clients do not need to be database owners. Have you prefixed all the objected that are used in vba, Forms, reports, etc... If so, I don't understand the question.

dbo.yourtable
dbo.yourSP