query timing out. how do you stop this from happening?

[Mitchell_Collen via AccessMonster.com]

What can be done to keep a querie from constantly timing out? Almost all my
queries and functions are doing this lately as my database grows. Any advice
on this is very much welcome.

Thanks, MC

 

[Guest]

There's only one practical way for us to know: Show us the SQL. Open the
query in design view. Next go to View, SQL View and copy and past it here.
Information on primary keys and relationships would be a nice touch too. Also
any indexes. Pick one of the queries that is timing out.

That said, one common problem is Cartesian joins. You need a join between
tables or else you could be creating millions of records. Is there a line
between the tables in the query design QBE grid? There needs to be.

Next I would be looking into indexing to make the query quicker.

After that I'd start looking at network and other connections especially if
the data is not in an Access database or on a local network.