Access Performance question...

[eskelies]

I have several linked tables, with lots of data in them. I have several queries using all this data, which is slowing down the speed of my database. I tried using the "analyze" function in Access, but because my tables are linked no indexing can occur.

Does anyone have any tips to make my Database run faster?

[jaxjagfan]

I have several linked tables, with lots of data in them. I have several queries using all this data, which is slowing down the speed of my database. I tried using the "analyze" function in Access, but because my tables are linked no indexing can occur.

Does anyone have any tips to make my Database run faster?

Minimize the number of table joins in a single query. Several small queries building up to eventual data you want is often faster than one massive query. If the data is analysis data (read only) then you may want to create some temp tables which groups and stores the results of your queries. This make s for a better end user experience as they get their results faster.

I truncate and load data analysis tables every day. Minimal or no linking required. End-Users can create their own queries and not have to know a lot of different tables.