Results 1 to 3 of 3

Thread: Linked table not sorting or filtering - ODBC error

  1. #1
    Join Date
    Aug 2012
    Posts
    1

    Linked table not sorting or filtering - ODBC error

    Hi,
    I have an Access 2010 database that I have recently inherited. I have moved the tables to SQL Server 2008 R2. One of the tables has 7 Primary keys. I can see the linked table in Access, open the table and query the table.
    But I am not able to sort or filter directly in the table. This is the only table that I am not able to sort / filter.
    The error when I try to sort or filter is: ODBC--call failed. [Microsoft][ODBC SQL Server Driver][SQL Server] incorrect syntax near 'ser_Location'. (#102)
    I have searched and it seems like no one else is having the same issue. If I remove the primary keys, I can sort / filter on the table but the table becomes not updateable. Is this an Access issue or SQL Server and how do I fix this problem?

    Thank you in advance

  2. #2
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    You need to have Primary Key for you to update the table via linked table in SQL Server.

    What do you mean by table having 7 primary keys, by definition you can only have one primary key in a table. Do you mean a primary key with seven columns in it?.

  3. #3
    Join Date
    Nov 2013
    Posts
    5
    I agree with skhana you need to have Primary Key.

Posting Permissions

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