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

    ODBC Connection Issue (Access 2002)

    New job, new duties and trying to make it all work. This is an AS/400 shop and they want me to produce "pretty" charts and graphs, so I attempted to connect to the AS/400 through ODBC and link to the files (tables) that way. I tested it by linking to one table (small--only 5000 records). The link was successful, but Access shuts down after 5-10 seconds each time I open the mdb. This occurs even if I don't try to access the linked table. Right now that one linked table is the only object in the mdb. Any ideas??

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,624
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: ODBC Connection Issue (Access 2002)

    I don't have any personal experience, but I've heard that the AS400 ODBC driver is flakey. I suppose that could cause Access to crash. What SPs have you applied?
    Wendell

Posting Permissions

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