After converting an Access 2003 application and data table to Access 2007,
queries became extremely slow.
This is a split application; front end runs local and tables are in a remote
server.
A simple query on a data table with 220 records returning two records, took
more than 2 minutes to complete.
The same query linking the database to an Access 2003 table, running on the
same network starting at the same time took just a few seconds to execute.
I converted to Access 2007, expecting better performance.
Any ideas, any settings I should e aware of, any changes in SQL coding, ...?

Hi,
make sure that you have latest SP installed, there was such bug in early
version of Access 2007

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com


"Cesar" <(E-Mail Removed)> wrote in message
news:190954A6-1CB7-4297-9500-(E-Mail Removed)...
> After converting an Access 2003 application and data table to Access 2007,
> queries became extremely slow.
> This is a split application; front end runs local and tables are in a
> remote
> server.
> A simple query on a data table with 220 records returning two records,
> took
> more than 2 minutes to complete.
> The same query linking the database to an Access 2003 table, running on
> the
> same network starting at the same time took just a few seconds to execute.
> I converted to Access 2007, expecting better performance.
> Any ideas, any settings I should e aware of, any changes in SQL coding,
> ...?
>