Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Jul 2002
    Location
    Ontario, Canada
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    AS400 link to Access (97)

    How do I (In layman terms) link up various table in an AS400 system to various tables within an Access Database. Example...I have a table in the AS400 that lists all of the Part that my company produces/sells/buys, and I would like to link it to an Access database that would sort/filter and display the part list and other various information.

    Thanks, Jay

  2. #2
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Mishawaka, Indiana, USA
    Posts
    145
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: AS400 link to Access (97)

    I know enough to maybe get you started.

    First determine what the database software is. For example DB2.
    Then go to Settings / Control Panel / Datasources(ODBC) / Datasource.
    Then install your ODBC driver. If the drivers are not on your list, you will have to obtain the driver.
    Try a search on the internet. For example,use the following search terms: ODBC Driver DB2

    After you have installed your driver do the following.
    Open your Access database.
    File / Get External Data / Link Tables / Files of type - select ODBC databases / Machine Data Source / Select a source name.
    Then you should be able to select your table on the mainframe.

    Good luck.

  3. #3
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: AS400 link to Access (97)

    If you want to link to AS/400 tables, you will need the ODBC drivers, which you may have to get from IBM. There have been prior threads on Access and the AS/400, including this one and this one, which might be of help to you.
    Charlotte

Posting Permissions

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