I've got a client who wants to keep running Access 2003, but wants the data
located in sql 2005.
I was able to migrate the data to SQL 2005, but when we attempted to run a
query
that took maybe 2-3 seconds for Access 2003 using internal tables (even
when run
on the network remotely thru a file share), took 30 seconds with Access
2003
using tables in an SQL 2005 database.
Is there anything I can do to speed this up?
--
Thanks in advance, Les Caudle
