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.
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.