Access klient slow down on SQL 2005 HELP PLZ

[Zanetti via AccessMonster.com]

Hio all,
I have huge problem with sql server 2005 , and access 2003 as front end
becouse my client is to slow . Same client works ok with SQL 2000 but when i
install 2005 that works bad and slow( open some form near 1 minut). So help
me plz

 

[Sylvain Lafontaine]

Maybe a bad query plans problem here. Rebuild the statistics using the
sp_updatestats stored procedure free the procedure caches:

DBCC FLUSHPROCINDB
DBCC DROPCLEANBUFFERS
DBCC FREEPROCCACHE

After that, try adding the WITH RECOMPILE option to your stored procedures
to see if this make any change and take a look at the potential parameter
sniffing problem (Seach Google on these terms).

 

[Zanetti via AccessMonster.com]

Maybe a bad query plans problem here. Rebuild the statistics using the
sp_updatestats stored procedure free the procedure caches:

DBCC FLUSHPROCINDB
DBCC DROPCLEANBUFFERS
DBCC FREEPROCCACHE

After that, try adding the WITH RECOMPILE option to your stored procedures
to see if this make any change and take a look at the potential parameter
sniffing problem (Seach Google on these terms).

Hio all,
I have huge problem with sql server 2005 , and access 2003 as front end

[quoted text clipped - 3 lines]

help
me plz

I install Access 2007 and i think taht he is faster then 2003. But i also
try your metod .TNX