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
|
|||
|
|||
Linked Tables - indexes
I have most of my tables in my front-end Access 'linked' to a sql server back-
end. I have some reports that take a couple of minutes to run (sql reports, not access). When running a query plan or optimizer it tells me of some indexes to add on the back-end sql tables. When adding these indexes the reports now run very fast or instantaneous. The problem I have now is that I get errors on my front-end saying Timeout occurred. Has anyone had any experience with this and why would my front-end act like this all of a sudden? Thanks. -- Message posted via http://www.accessmonster.com |
#2
|
|||
|
|||
Linked Tables - indexes
On Thu, 25 Mar 2010 19:46:32 GMT, "osupratt via AccessMonster.com"
u41837@uwe wrote: I have most of my tables in my front-end Access 'linked' to a sql server back- end. I have some reports that take a couple of minutes to run (sql reports, not access). When running a query plan or optimizer it tells me of some indexes to add on the back-end sql tables. When adding these indexes the reports now run very fast or instantaneous. The problem I have now is that I get errors on my front-end saying Timeout occurred. Has anyone had any experience with this and why would my front-end act like this all of a sudden? Thanks. If you're using ODBC to link to the tables, Access has stashed some information about the backend table in the frontend, and by changing the structure of the backend (by adding an index), the information is out of date. I've gotten in the habit of routinely *deleting* the link from the frontend and using File... Get External Data... Link... ODBC to relink to the table after any structural change to the table. -- John W. Vinson [MVP] |
Thread Tools | |
Display Modes | |
|
|