Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2009
    Posts
    1

    Unanswered: ODBC - connection to '|' failed

    I'm trying to link tables from a SQL Server database to an Access 2007 front-end. My desktop is WinXP, I have successfully created the ODBC on my desktop and linked the tables in Access. The Access has a number of Macros and gets hung on load file that is an Excel 2007 spreadsheet. I have checked the Macro and I don't see any errors. The Macro halts and then gives me the error message --> ODBC - connection to '|' failed.

    Any ideas?

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Sounds more like an MS Access issue, so I am moving this to the Access forum.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  3. #3
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    1. A table cannot be both a SQL Server linked table and an Excel spreadsheet. Which one is it?
    2. What's the code (Sub or Function) in which the error occurs? Obviously there must be an error somewhere.
    Have a nice day!

Tags for this Thread

Posting Permissions

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