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
|
|||
|
|||
Reports Access 2007
Hi,
I have an Access 2K reporting solution that pulls data (40 rows) from a remote SQL server database using a paramatised stored procedure call - A particular report runs in under 6 seconds without fail However, the same report returns in Access 2007 in nearer 17 seconds! This is true for an .mdb, acdb and acde version of the database Interestingly, the passthrough query that is the data source for the report, returns the 40 rows in a similar time on both versions of Access. It seems to be taking an extended length of time to render the data if the data is not local To confuse the issue, if I run the passthrough query as a make table query and run the report against this table we're back to circa six seconds for both actions. Your thoughts why Access 2007 is behaving this way would be appreciated PS I created a version with no modules or forms with the same results Regards Kieran |
Thread Tools | |
Display Modes | |
|
|