Hi VBA guru's

I need to improve my VBA access application which has couple of queries joining different Tables, the main challenge I am having is that it decrease the speed of queries after creating indexes. I have no clue why it is happening and how i can check that Table is using my created Indexes.

Please let me know what else i can do.

you answer is greatly appreciated.

Jani

What indexes have you created?

Normally you would have one clustered index on a primary key field per table, and then a non clustered index on each of your look up fields.

How bad is your performance, and what types of queries are you trying to run where performance is an issue? Also, what is the application environment? Sometimes it is the environment and not the queries themselves that is the problem.


mmcdonal

Look it up at: http://wrox.books24x7.com