Results 1 to 3 of 3

Thread: Linked Table

  1. #1
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1

    Unanswered: Linked Table

    I have a linked table from Informix in Acce$$, When I want to add a new recor to that table it says, This Recordset is unupdatable.

    While I have the same linked table in another Acce$$ DB but I can Add Records.

    If I delete the linked table form the first DB and copy it from the secound DB it becomes uupdatable

    What can be the cause?

    Thanks

  2. #2
    Join Date
    Jan 2004
    Location
    Islamabad, Pakistan
    Posts
    97
    To me it seems like when the table is open from db1 and table is being used in that db1 the other database can't open it in editable form from db2 or vice versa.

    - Saqib

  3. #3
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1
    Thank you for your reply, but I mad sure that I was the only user for that DB. The file was only opend by me.

    Any way I deleted the linked tables and linked it again. It functions now.

Posting Permissions

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