Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Oct 2002
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Linked server problem - Access 97 - please help (Access 97)

    I'm having a bit of a problem, and I can find nothing that
    will help me. Hopefully, you experts can help.

    I have an Access database which contains linked tables to
    a DB/2 warehouse, and connect via an ODBC dsn. When the
    first table is opened, the ODBC driver prompts the user
    for the userid/password for the data warehouse.

    If the user closes the table, but keeps the database open
    for more than 10 minutes, then when the user tries to
    reopen the table, Access 97 bombs, and shuts down. I
    realize there's a timeout coming from the warehouse after
    10 minutes, but I cannot find how to tell Access to re-
    login and prompt the user for userid/password again. If
    so, this would avoid Access dying and the user losing any
    other work that has not been saved, i.e., working on
    another query, report, etc.

    I understand that Access pools the connection data
    locally. However, when I set the registry to timeout
    after a certain amount of time, Access 97 still dies.

    Is there any way I can prevent Access from dying, and/or
    making the ODBC driver DSN to prompt the user for logon
    credentials after this timeout?

    Thanks for any help you can give.

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

    Re: Linked server problem - Access 97 - please help (Access 97)

    I would guess that your problems lie in the ODBC driver for DB/2 more than they do with Access per se. It sounds like what is happening is that the DB/2 warehouse has a 10 minute timeout that shuts down the connection after no activity. The only thing I can suggest if that is what is going on is to create a timing loop that touches the table every 5 minutes or so while the Access database is open. I should add that you might have significantly less problems with a later version (2000 or 2002) of Access, as there should be newer DB/2 drivers for those versions, and they are significantly more stable in a linked ODBC environment.
    Wendell

  3. #3
    New Lounger
    Join Date
    Oct 2002
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Linked server problem - Access 97 - please help (Access 97)

    I totally agree with what you said. Thank you for your guidance, and I will concentrate on working around that driver problem. I like you idea about hitting the database (if I can't fix the driver). Thank you for the suggestion. I do appreciate your help.

    And I am in total agreement about upgrading Access. Now, if I could just get the managers to buy in to it!!!

    Again, thank you so much.

Posting Permissions

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