I am trying to insert a record in ODBC Linked Table through Code from Access 2000 front end using ADO.
No relationships exist and I have full rights on the table.
Each time I succeed in creating the record, but on editing the record, I get a write conflict.
I have tried uing an append query instead, but the Write conflict persists.
I can not delete the record through Access, but have to delete it from SQL Server
Any ideas anyone?
Regards
Hans
No relationships exist and I have full rights on the table.
Each time I succeed in creating the record, but on editing the record, I get a write conflict.
I have tried uing an append query instead, but the Write conflict persists.
I can not delete the record through Access, but have to delete it from SQL Server
Any ideas anyone?
Regards
Hans