Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    Feb 2010
    Location
    Denver, CO
    Posts
    191
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Link to AS/400 (Access 2002)

    I am embarking on a new project which will require me to use MS Access as a front-end reporter to a live AS400 database. I plan to connect through ODBC, unless there is a better way. I am pretty much a newby with it comes to AS400. I have quite a bit of experience at linking to external SQL Server tables. Would there be a significant difference?

    1. <LI>Does anyone have any experience with this? As far as Access is concerned, is it much different that linking to other external tables?
      <LI>I am particularly concerned about degrading performance on the AS400 due to the ODBC calls.
      <LI>Can anyone point me to a primer or whitepaper on ODBC connectivity with an AS/400?
    Thanks

  2. #2
    Star Lounger
    Join Date
    Oct 2002
    Location
    Sheffield, Yorkshire, England
    Posts
    80
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Link to AS/400 (Access 2002)

    Randall

    I connect to an AS/400 database through ODBC and use Access as a report writer. The table linking process is the same as other external table however care needs to be taken over opening tables due to the amount of records involved. What I tend to do is create a make table query of the records I require and then run the report from this local table.

    Graham

  3. #3
    2 Star Lounger
    Join Date
    Feb 2010
    Location
    Denver, CO
    Posts
    191
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Link to AS/400 (Access 2002)

    Graham--

    Thanks for the information. I'll keep your Make Table solution handy. I am interested in your "care needs to be taken when opening tables" comment. Is this because Access has a hard time handling the number of records (which I'm sure is true--one of the files in this database has over 8M records), OR are you saying this causes a performance degradation in the AS/400. Does querying the AS/400 cause any performance issues? My marching orders are that my solution should have little or preferrably no decernable performance degradation on the AS/400.

    Randy

  4. #4
    Star Lounger
    Join Date
    Oct 2002
    Location
    Sheffield, Yorkshire, England
    Posts
    80
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Link to AS/400 (Access 2002)

    Randall

    There are no noticeable performance issues on the AS/400 in my experience - the limitation is Access. You definitely do not want to be reading 8M records into Access.

    Graham

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •