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