ADO is slow with AS/400 Database

I'm using ADO to retrieve data from an AS/400 Database, for small reports,
the performance is acceptable, but for larger query, its a bit slow and at
times, it takes up all the memory of my development machine. Does anyone
have a better approach to this issue?

Thanks.


.

Relevant Pages

  • Re: Newbie? Do I use Report or Query
    ... Makes reading your database easier! ... Table JobDetails ... Reports are the counterpart of Forms. ... If based on a query, ...
    (microsoft.public.access.gettingstarted)
  • Re: running report cause fatal error- on Win98, not XP
    ... It is actually not that difficult to crash JET with complex queries, ... another query. ... only the more complex reports cause the crash- the others do ... Then compact the database: ...
    (microsoft.public.access.reports)
  • Re: running report cause fatal error- on Win98, not XP
    ... another query. ... only the more complex reports cause the crash- the others do ... Then compact the database: ... Still in the code window, choose Compile from the Debug menu. ...
    (microsoft.public.access.reports)
  • Re: running report cause fatal error- on Win98, not XP
    ... In the final query that the report ... only the more complex reports cause the crash- the others do ... Then compact the database: ... Still in the code window, choose Compile from the Debug menu. ...
    (microsoft.public.access.reports)
  • Re: Take database, copy & edit, have reports reflect changes
    ... >I've tried two different things with the database. ... but the reports wouldn't show my reflections. ... this will be a query selecting *some* fields (not the newly added ... and a Query Design window will ...
    (microsoft.public.access.gettingstarted)