BW/4 HANA OpenHub to MS-Access with ODBC

[mikeseiferth]

Hi all,

we are currently setting up our new BW/4 system and do have several OpenHubs where there is a need to process the data in MS-Access (for historical reasons). All that worked fine with BW 7.5 on DB2.

Any OpenHub table or any ADSO that we try to access with the HANA ODBC driver as linked tables leads to data that is marked with #DELETED in MS-Access.

Does anyone use MS-Access with ODBC connection to HANA and has any idea how to solve this issue?

An SAP note says: This is a Microsoft problem.

Thanks and best regards,
Michael

[mikeseiferth]

@Charles:
Thank you for the hint - I have already seen this note but cannot really believe that nobody else is using BW/4 OpenHubs with MS-Access via ODBC. So it would be intersting for me if anyone uses a workaround for that.