SQL Express faster than SQL 2005

[Zigzag]

Hi

I have MS Access 2003 FE running against an SQL 2005 Development server or SQL 2005 Express server.

When I run it against the SQL server all is good but when I run it against the SQL 2005 Development server the speed is around 5 – 6 times slower.

Both Access and the servers are on the same development machine.

The version numbers of both servers are the same (9.0.4035).

Does anyone know why this is happening?

Garry

 

[Zigzag]

Thread update.

I have managed to find a solution to my problem.
I have been using the MDAC ODBC driver to connect to the SQL servers which works well with SQL 2005 Express but not for SQL Developer Edition so I have changed the connection string.

From ‘MDAC ODBC connection’
oConn.Open "Driver={SQL Server};" &
"Server=MyServerName;" & _
"Database=myDatabaseName;" & _
"Uid=myUsername;" & _
"Pwd=myPassword"

To ‘SQL Native Client Driver for SQL 2005)’
oConn.Open "ODBC;Driver={SQL Native Client};" &
"Server=MyServerName;" & _
"Database=myDatabaseName;" & _
"Uid=myUsername;" & _
"Pwd=myPassword"

I did a check on my MDAC version and it shows as 2.8 which I believe is the latest version.
I still don’t quite understand why the MDAC works with one but not the other.
However the SQL Native client works well with both.