SAP Knowledge Base Article - Preview

2445163 - MS Access shows #deleted with decimal, money, numeric datatype - SDK for SAP ASE

Symptom

  • Numeric, money, and decimal column retrieved by Microsoft Access through ODBC Driver "Adaptive Server Enterprise" get #DELETED.
  • The column must be in an index with another column:
    • create unique clustered index testtab_ucidx on testtab (col1)
    • Select this column and another column as identity columns when creating MS Access linked table


Read more...

Environment

  • SAP Sybase Software Developer Kit (SDK) 15.0
  • SAP Sybase Software Developer Kit (SDK) 15.5
  • SAP Sybase Software Developer Kit (SDK) 15.7
  • SAP Sybase Software Developer Kit (SDK) 15.7
  • SAP Adaptive Server Enterprise (ASE) Software Developer Kit (SDK) 16.0
  • Adaptive Server Enterprise ODBC Driver by Sybase
  • Microsoft Access

Product

SAP Adaptive Server Enterprise 12.5 ; SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0 ; SAP Adaptive Server Enterprise SDK 16.0 ; Sybase Adaptive Server Enterprise 12.5 ; Sybase Adaptive Server Enterprise 15.0 ; Sybase Adaptive Server Enterprise 15.5 ; Sybase SDK 15.7 ; Sybase Software Developer Kit 15.7

Keywords

ms access, microsoft, 2007, 2008. 2016, 2012, odbc, missing, no data, empty, retrieve, find, wrong, bug,  , KBA , BC-SYB-SDK , SDK , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem

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.