I have just "upgraded" to sql server and am finding it to be terribly slow. Whay?<BR><BR>thanks
Something is probably wrong. Or maybe SQL Server is slower than Access.<BR><BR><BR>Yo ho ho and a bottle of rum.
Does it matter that I am connected to it through Enterprise manager?
Yo ho ho and a bottle of rum.
what type of connection string are you using<BR><BR>or rather what data provider.<BR><BR>oledb is the best right now.<BR><BR>I have found that oledb can make queries run faster.
Database_Connect = "Provider=SQLOLEDB;Data Source='ip address';Initial Catalog=cat;User Id=name;Password=pass;Connect Timeout=15;"