Re: Speed Improvements With SQL Server?

Per Larry Linson:
Not only that, but Access MDB/ACCDB <--> Jet/ACE <--> ODBC <--> serverDB is
the configuration for Access clients currently recommended by the Access
team, not ADP.

Can anybody speculate on why?

On the several apps where I was forced to stay with ODBC against
tables migrated to SQL Server, response time went right down the
toilet.

OTOH, on the one app where I got to do it my way from the bottom
up (ADO, stored procedures for *everything*) I was pleasantly
surprised by how quickly it loaded/saved some fairly heinous
screens - and I don't know diddley about SQL Server, the whole
thing was done on a wing and a prayer.... heaven forbid somebody
who knew what they were doing should have done the DB design and
written the SPs.
--
PeteCresswell
.