Results 1 to 2 of 2
  1. 03-23-2009, 02:27 PM #1
    tcroninstl
    tcroninstl is offline Novice
    Join Date
    Mar 2009
    Posts
    1

    Linked table to sql 2000 db

    I am trying to user with an app they have. The have an access 2003 db that has some linked sql server tables. All the tables link fine except for one which shows #name after getting an ODBC error in all the fields. I even tried this with my dba account when linking and get the same error. I have seen this before and can't remember what causes it. (The table that is an issue does have a primary key on it)
    Reply With Quote Reply With Quote
  2. 03-23-2009, 07:27 PM #2
    RuralGuy's Avatar
    RuralGuy
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Can you delete the link and relink the table?
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Access 2000
    By jerald in forum Access
    Replies: 1
    Last Post: 03-15-2009, 04:12 PM
  2. Using Linked Table Manager --Can't get it work
    By cccgsmith in forum Access
    Replies: 6
    Last Post: 03-11-2009, 06:43 AM
  3. What Corrupted an MS SQL 2000 Table ?
    By dickyfinn in forum Access
    Replies: 0
    Last Post: 02-22-2009, 05:28 PM
  4. Editing a Linked Table
    By amndza in forum Access
    Replies: 2
    Last Post: 01-21-2009, 01:27 PM
  5. Linked Table Manager
    By driccardi in forum Access
    Replies: 4
    Last Post: 02-15-2006, 11:47 AM

Posting Permissions

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

Forum Rules

Other Forums: Microsoft Office Forums