RE: Link AS400 database wirh Access Database

["Gary Monnier" <gary.monnier@xxxxxxxxxxxxx>]

There are many ways to solve your dilemma. One is, unless you really
have your heart set on doing this through Access, is to use a logical
file keyed in the sequence you want your query in and run your query
over the logical view.  Using this logical view will reduce the amount
of time and CPU your query uses.  And yes, it will take some CPU to
build the logical view, but you can schedule it to be created/installed
during slow hours.

If your file is really enormous you may be better off writing a program
to spin through it, filter out records you don't want to report on,
write those that you do want to report on to a separate physical file
and run your query over your new file.