Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2007
    Posts
    348

    Unanswered: extending ODBC time out

    I'm not sure this is truely and access question and I don't think these is much I can do but I wanted to run it by you guys.

    My work PC got replaced including and upgrade to Office 07. I fired up Access 07 today and am having some pain in adjusting. Most of it, I think I will work though. There is one thing though. I use an ODBC connection to our Datamart. It is failing early and often. I know I have pulled this kind of data on '03 with no trouble.

    Is there anything I can do from the end-user perspective to discourage and ODBC timeout?

  2. #2
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Because your environment is an unknown here, the best thing I can do is direct you to your systems administration people and ask them to see what they can do to help.

    All I can suggest is clicking that big ugly office button, selecting Access Options (formerly know as Tools - Options) and then clicking on Advanced. At the bottom of that there are some DDE/OLE/ODBC options that might be worth a look at.

    Mind you, setting the timeout to like 10 minutes might save you some crashes, but I wouldn't be happy with any system that had such a lag. I think you need to look at why it's failing more than patching it with a longer timeout. A new system upgrade should not need timeouts extended!!
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  3. #3
    Join Date
    Feb 2007
    Posts
    348
    ah, that looks like what I need. Thanks. I'll get in touch with the admin for his preferences with regard to time out periods and so on. Thanks for showing me where to look though.

Posting Permissions

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