Can anyone help please?

I have Access Projects Front ends 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.


george

Are you using Access data Projects (ADP) or MDB files?
IF ADP's then you should be aware that Access 2000 adp's were not designed for SQL 2000 let alone 2005.

You have already identified a possible solution -- standardize everyone on Access 2003 or later. The other option which is one that should be done anyway to speed up object name resolution when parsing queries and that is to ensure that every object reference is qualified by owner name.

How are your access 2000 using authenticating? Windows or SQL? If SQL are they all using the same user or different users?

David Lundell
Principal Consultant and Trainer
www.mutuallybeneficial.com

David,
I am using ADPs and have discovered that if I ensure users are not members of the db_owner role then it's all OK.

However to ensure no further problems I have now qualified all the references to all objects with the owner. I hope to have most users on Access 2003 runtime environment soon also.

Thanks for the comments.
George.

george