Slow performance of linked dbs

[Denise]

The UNC looks something like this \\serverlevel1\serverlevel2\folder1\filename.mdb. Does this address have something to do with extreme slowness searching. Select query is looking for all active records for assigned to a specific person.

 

[TC]

If you are running a query that is searching a table for certain records,
and the query is running very slowly, this would suggest that the relevant
field(s) have not been Indexed, and/or, the table has not been properly
designed.

What is the structure of the table being searched, and what is the SQL that
you are searching it with?

HTH,
TC

The UNC looks something like this

\\serverlevel1\serverlevel2\folder1\filename.mdb. Does this address have
something to do with extreme slowness searching. Select query is looking
for all active records for assigned to a specific person.

 

[Allen Browne]

For a list of the issues you might try, take a look at Tony Toews
"Performance FAQ":
http://www.granite.ab.ca/access/performancefaq.htm

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

The UNC looks something like this

\\serverlevel1\serverlevel2\folder1\filename.mdb. Does this address have
something to do with extreme slowness searching. Select query is looking
for all active records for assigned to a specific person.

 

[Denise]

Thanks. I ran Access performance tool and it make some changes to relationships and indexes. So tomorrow when I test on client's network, I hope to see some improvement. Thanks again.