Hi there,
I have a MS access 2003 database with SQL linked table. When i am trying to update one particular record i am getting write conflick error.
I have tried all the solutions suggested by different sites like changing the lock to Edited Record and Setting the default value.
But the record is giving error on updating any field regardless of what field i am updating. So cant set the default value for all the fields.
Please advise!
I have a MS access 2003 database with SQL linked table. When i am trying to update one particular record i am getting write conflick error.
I have tried all the solutions suggested by different sites like changing the lock to Edited Record and Setting the default value.
But the record is giving error on updating any field regardless of what field i am updating. So cant set the default value for all the fields.
Please advise!