Slow connection from Access 2003 to SQL Server 2008

[giedriusz]

I use Access 2003 ADP and SQL Server 2008.
Loading first Access form after connecting to SQL Server 2008 is very slow.

When I traced performance with SQL Server Profiler, I had found that slow
performance was caused by build in function permissions() in query:
------------------------------------------------------------------------------
-------------------------------
select object_name(id), user_name(uid), type, ObjectProperty(id,
N'IsMSShipped'), ObjectProperty(id, N'IsSchemaBound') from sysobjects where
type = N'V' and permissions(id) & 4096 <>0
------------------------------------------------------------------------------
-------------------------------

It is internal Access 2003 query. It looks like Access is checking user
permissions.

I executed that query using the same database with different users and SQL
Servers:

Execution time:
SQL Server 2008 Enterprise Edition user:sa - without delay
SQL Server 2008 Enterprise Edition user:xx Database role: db_owner - 8 sec.
SQL Server 2008 Enterprise Edition user:yy Database role: db_datawriter,
db_datareader - 40 sec.

SQL Server 2005 Developer Edition user:sa - without delay
SQL Server 2005 Developer Edition user:xx Database role: db_owner - without
delay
SQL Server 2005 Developer Edition user:yy Database rolea: db_datawriter,
db_datareader - without delay

Is it normal for MS SQL 2008?

Thanks in advance.

 

[Luc]

Hi I have same problem with Access 2007 and SQL 2008. But if my username is
sysadmin server role the problem does not occur.