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 ONE Support launchpad (Login required).

Search for additional results

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