User Profile

Collapse

Profile Sidebar

Collapse
chrisgia
chrisgia
Last Activity: Jan 10 '12, 01:57 PM
Joined: Aug 30 '11
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • chrisgia
    replied to bypass odbc connection
    in Access
    thank you. I will give it a try.
    See more | Go to post

      Leave a comment:

    • chrisgia
      replied to bypass odbc connection
      in Access
      Hadn't caught that but now I see it. This is exactly what I want to do but have no idea how to.
      See more | Go to post

        Leave a comment:

      • chrisgia
        replied to bypass odbc connection
        in Access
        I have 70+ users using this query on a daily basis. Most days all the connections are good. The connections are to each of my locations across the east coast. With weather and/or equipment issues there are times that one or more locations are down. I do not want to rebuild the query each time something happens.
        See more | Go to post
        Last edited by NeoPa; Aug 31 '11, 03:16 AM. Reason: There's absolutely no need to quote the previous post - that's just not clever.

          Leave a comment:

        • chrisgia
          started a topic bypass odbc connection
          in Access

          bypass odbc connection

          I have a MS Access 2007 database that contains a union query that merges 5 different odbc connections. If one connection is down I receive an 'ODBC--call failed' error and the query is unusable. Is there a way to have the database verify connection and if it cannot connect to one or more odbc, to simply by-pass the odbc(s) and use the others?
          See more | Go to post
          No activity results to display
          Show More
          Working...