"dbo." Table qualifier in Access Project on sql backend (1 Viewer)

gvcooper

New member
Local time
Today, 17:34
Joined
Apr 22, 2006
Messages
6
Can anyone help please?

I have Access Projects on SQL 2005 backends.

Some users are on Access2000, some are on Access2003 and some use Access2003 RunTime only.

I have no problems with the Access 2003 full versions or runtimes. But with Access 2000 users, some can't use any forms or reports where the Recordsource property does not have the full qualifier:-
e.g "SELECT * FROM dbo.Employee" .

However some Access 2000 users work OK with "SELECT * FROM Employee" (without the "dbo." qualifier)

Is there an option somewhere in Access 2000 to set whether or not the full qualifier is needed?
Is there a service pack difference?

Thanks for any help.
 

SQL_Hell

SQL Server DBA
Local time
Today, 08:34
Joined
Dec 4, 2003
Messages
1,360
could you not just set the qualifier in all instances?
 

gvcooper

New member
Local time
Today, 17:34
Joined
Apr 22, 2006
Messages
6
Fixed

The issue related to users who where also members of the Database role DB_Owner. I removed them from this role and all is well.

Thanks.
 

Users who are viewing this thread

Top Bottom