• ODBC Connection Issue (Access 2002)

    Home » Forums » AskWoody support » Productivity software by function » MS Access and database help » ODBC Connection Issue (Access 2002)

    Author
    Topic
    WSrrdavis
    AskWoody Lounger
    October 21, 2003 at 2:40 pm #395341

    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??

    Reply | Quote
    Viewing 1 reply thread
    Author
    Replies
    • WBell
      AskWoody_MVP
      October 22, 2003 at 2:54 am #732832

      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?

      Reply | Quote
    • WBell
      AskWoody_MVP
      October 22, 2003 at 2:54 am #732833

      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?

      Reply | Quote
    Viewing 1 reply thread
    Reply To: Reply #732832 in ODBC Connection Issue (Access 2002)

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information:




    Cancel
DON'T MISS OUT!
Subscribe to the Free Newsletter
We promise not to spam you. Unsubscribe at any time.
Invalid email address

View the Forum

  • Recent Replies
  • My Replies
  • My Active Topics
  • New Posts in the Last day
  • Private Messages
  • Knowledge Base
  • How to use the Forums
  • All Forums

    • Recent Topics

    My Profile

    June 2025
    S M T W T F S
    1234567
    891011121314
    15161718192021
    22232425262728
    2930  

    Remembering Woody

     

    Want to Advertise in the free newsletter? How about a gift subscription in honor of a birthday? Send an email to sb@askwoody.com to ask how.

    Mastodon profile for DefConPatch
    Mastodon profile for AskWoody

     

    Home • About • FAQ • Posts & Privacy • Forums • My Account
    Register • Free Newsletter • Plus Membership • Gift Certificates • MS-DEFCON Alerts

    Copyright ©2004-2025 by AskWoody Tech LLC. All Rights Reserved.