Acces 2007 performance



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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question