Re: Using MSAccess and needed info from iseries DB question

I once chopped an Access / VB application down from 4 hours to < 5 minutes by moving the entire thing to the iSeries. The Access app was merely sucking in all of the master files from the iSeries, doing its thing and, then, pushing the finished result back to the iSeries.

But it wasn't doing any printing, just building a price list. We still use Access and Excel for the executive reports instead of the iSeries; the execs love all of the coloring and fancy fonts, but won't let me buy the AFP product or link the iSeries to the color printer.


The only thing that comes to mind, perhaps, is pulling all of the data you need from the iSeries in one pass (maybe additional tables) rather than making multiple round trips. ODBC just seems to be slow based upon our experience, so the fewer trips the better probably.


* Jerry C. Adams
*IBM System i5/iSeries Programmer/Analyst
B&W Wholesale Distributors, Inc.* *
voice
615.995.7024
fax
615.995.1201
email
jerry@xxxxxxxxxxxxxxx <mailto:jerry@xxxxxxxxxxxxxxx>



tim wrote:

I am using MSAccess to print some reports. The number of reports is based on
how many records are in the access table. For each access table record I
need to get information from an iseries DB. I am using ODBC and SQL but
seems to be a bit slow. Is there a faster way of performing this function.
Basically I want to chain to the iseries for each record read.


Thanks