Results 1 to 11 of 11

Thread: Linked tables

  1. #1
    Join Date
    May 2003
    Posts
    70

    Unanswered: Linked tables

    I have an access mdb with ODBC table links to a SQL Server database (MSDE).
    I can update the data in most of the tables except some where I get the message
    ODBC--update on a linked table TABLENAME failed.

    Now I understand that the SQL server table must have a unique index which it does.

    It has a primary key indes which is also unique. Is that sufficient??
    Why is this happening?

    Thanks,

  2. #2
    Join Date
    May 2003
    Location
    Dallas
    Posts
    817
    Provided Answers: 5
    how are you trying to update the tables?

  3. #3
    Join Date
    May 2003
    Posts
    70
    First through ADO in VB and then I tried from within Access itself. It updates one table with almost identical design with similar indexes but not the other.

  4. #4
    Join Date
    Jan 2003
    Location
    Vietnam
    Posts
    188
    have you tried delete the linked tables (having problem) and create them all again?
    qha_vn

  5. #5
    Join Date
    May 2003
    Posts
    70
    Yes, I have. Same results.

  6. #6
    Join Date
    May 2003
    Location
    Dallas
    Posts
    817
    Provided Answers: 5
    through SQL itself can you update the table?
    Have you looked at permissions

  7. #7
    Join Date
    Jan 2003
    Location
    Vietnam
    Posts
    188
    Originally posted by vbgladiator
    Yes, I have. Same results.
    if your client is in windows environment, think of connecting to msde by microsoft recommended way (data access project) and not by odbc. of course, if possible in your case.

    hope this helps
    qha_vn

  8. #8
    Join Date
    May 2003
    Location
    Dallas
    Posts
    817
    Provided Answers: 5
    access project is the cleanest way but if you can manipulate data using your present method on other data then connectivity is not the issue - permissions or updating methods are the issue - at a more drill down level - perhaps the tables are not really as identical as you may think.

    HTH
    axsprog

  9. #9
    Join Date
    Jan 2003
    Location
    Vietnam
    Posts
    188
    it was just a comment. in my opinion, we need to figure out all the possible alternatives that may solve the prolem.

    you are right about the connectivity, but its not true that if odbc can work well on this table/ query, it can work well on all other tables/ queries. problems just arise on certain circumstances.
    qha_vn

  10. #10
    Join Date
    May 2003
    Posts
    70
    Hi,

    Whether I try through SQL or from within Access itself, I receive the following message:

    ODBC - update on the linked table TableName failed.

    It works fine on most tables. I only have this problem with a couple of tables.

    Thanks

  11. #11
    Join Date
    May 2003
    Location
    Dallas
    Posts
    817
    Provided Answers: 5
    Create a new table that is identical in structure with the table that is fine.
    Can you add records at this point?
    Look at the structure - what is different from the problematic table?
    Are you passing parameters? Are the indecies the same data types?

    Take the problematic table and remove one field at a time - divide and conquer - do you have permissions to create tables on the SQL server?

    Are you inserting or updating records?

Posting Permissions

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