C
Cesar
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, ...?
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, ...?