Slow response when making changes to reports? Why?

[MikeB]

I have a database built on Access 2003. All tables (3) are ODBC connections
to our AS400.

Running queries are fairly quick, but when it comes to creating reports or
making changes to reports it all runs in slow motion. Just to highlight a
field to make a simple change takes minutes. Any ideas why?

My first impression was the ODBC connections? If this is it, are there any
changes I can make to speed things up.

Thanks for your help,
MikeB

 

[Rob]

I'm not sure what might be causing the performance you
describe, but one suggestion would be to add a little
extra overhead to the process by having your queries dump
data into temp tables and then base the reports off the
temp tables. This would localize all of the overhead
associated with report editing to your PC.

You would need to create a macro or write some code to
first run a delete query to empty the temp table, then run
an append query to populate it, and then finally open the
report.

Which version of Access are you using, and which ODBC
driver?

Rob

 

[MikeB]

Rob,

Using Access 2003, ODBC is Client Access (ODBC) IBM 8.00.05.07.

Thanks for the help,
MikeB

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~