If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Slow performance of linked dbs
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.
|
#2
|
|||
|
|||
Slow performance of linked dbs
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 "Denise" wrote in message ... 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. |
#3
|
|||
|
|||
Slow performance of linked dbs
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. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Denise" wrote in message ... 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. |
#4
|
|||
|
|||
Slow performance of linked dbs
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.
|
Thread Tools | |
Display Modes | |
|
|