Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004

    Unanswered: invalid object error

    I'm have linked tables in Access that connect to tables in SQL Server. When I try to run a form or report in Access, I get the following error:

    Could not execute query: could not find linked table
    [Microsoft][ODBC Sql Server Driver][Sql Server] Invalid object name
    ‘ownername.tbl_Individual_Tool’. (#203)

    I removed the owner table prefix that was appended to the linked tables in Access.

    I'm stumped on what I should be looking for or how to proceed in troubleshooting the error. I didn't have any luck googling. Any help is appreciated.

  2. #2
    Join Date
    Oct 2003
    Provided Answers: 1
    Check the ODBC connection

Posting Permissions

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