SQL Server & Ms Access

I have created an appliation in MS Access XP as an .adp and linked it to SQL2000 Server all was well until I set up security on SQLServer for individual user groups from the Win2003 profiles. The result was that all table, sp and view names achieved the addition of (dbo) after their name e.g. tblCustomer(dbo) within the access application. Only when logged on as administrator did the new name extension go and the application run again. I need to remove the extension - or go through all the code renaming! Please can anyone advise where I have gone wrong and or what the solution is.


Many thanks

John