Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2002
    Posts
    1

    Angry Unanswered: Access 2000 linked tables

    I'm writing a program to update a few field on an external database which I'm linking to with the XTG Systems InterBase6 ODBC driver. The code executes fine, but the linked table does not update. I tried importing the table and running the code on the imported table, and it worked perfectly, so I don't think that it is the problem.
    If I go into the actual linked tables, some of the fields I want to update, I can update manually, and others that are updated in a seperate part of the program give me a 'Write Conflict, record has been changed by another user...' error.
    If anyone could help me it would be great. Thanks!

  2. #2
    Join Date
    Oct 2001
    Location
    Bay Area, CA
    Posts
    117
    looks like you don't have permission to write/update the data in the external DB. Change the privileges in that system. If the DB is on a LAN, the security on the LAN might have to be changed to grant you write access.

    Hope this helps...

Posting Permissions

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