SPEED UP QUERIES

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I have an Access 2003 database on a LAN shared network drive containing
simple queries created using the design view. The problem is, they are SOOO
slow! Can anyone help me with tips to speed up the queries so that they run
more quickly over the LAN?

thanks very much for your help!

Cheers
Barbara
 
Barbara

Are you saying you have an Access database, unsplit, housed on a network
share? That would require passing massive chunks of the program and the
data back and forth. I'm surprised the network police haven't taken away
your permissions!

First, I'd suggest that you work with a split database arrangement -- the
data in a back-end on the network, and everything else (including queries)
in a copy of a front-end on your PC (and another copy on each/every other PC
that needs to work with the data). Link to the back-end tables to give the
front-end .mdb some data to work with.

Next, I'd look at whether your network's antivirus software is messing with
Access. We had a 1-2 second query drop to "minutes" after an "update" to
the antivirus software. It took some dedicated "sniffing" by the network
folks to find this out.

Finally, I'd suggest making sure your data is properly indexed. Each field
participating in joins or WHERE (criteria) clauses are candidates for an
index. If your back-end already has table relationships set, you don't need
to re-index these.

You can also check at Tony's website for more ideas:

www.granite.ab.ca/accsmstr.htm
 
Back
Top