SAP Knowledge Base Article - Preview

2069991 - Unable to Update or Delete Records in Advantage Linked Table in Microsoft Access

Symptom

  • When attempting to update a record in a linked table via ODBC in Microsoft Access, the following error is returned:
    • "This record has been changed by another user since you started editing it. If you save the record, you will overwrite the changes the other user made."
  • When attempting to delete a record from the same table the following error is returned:
    • "The Microsoft Access database engine stopped the process because you and another user are attempting to change the same data at the same time."


Read more...

Environment

  • SAP Advantage Database Server (All versions)
  • Sybase Advantage Database Server (All versions)
  • Advantage ODBC Driver
  • Microsoft Access

Product

SAP Advantage Database Server all versions ; Sybase Advantage Database Server all versions

Keywords

ADS, Sybase, open, database, connectivity, configuration , KBA , BC-SYB-ADS , ADS (Advantage Database Server) , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.