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!
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.