Hi,
I have a re****t in access that used to run on linked tables to other
access
databases. the re****t it's self did a lot of work and used to produce a 27
page re****t in about 3 seconds.
i have upsized the database to SQL server 2005 and the re****t is now bound
to a linked table with is a SQL view, so all the re****t has to do is read
about 5000 lines of data from the linked table, all the work is done buy
the
sql server.
the view will open on the SQL server is less than a second, the liked
table
in access that is linked to the view will open in about 2 seconds but when
the re****t is opend it takes 9 seconds.
3 times longer than before. this is a bit of a problem as the re****t is
run
every time a bill is printed and and making a bill run which has sevral
thousands of bill much slower than it was before.
can any one help me speed this up ?
