How to connect from Microsoft Access 2016 to SAP Hana database using ODBC file Less DSN string

[former_member1195349]

I want to believe that SAP Hana database is like any other database , example SQL Express server where data is being stored in , now suppose I want to use Microsoft Access 2016 as a front end and store data in the database, how can we use ODBC string?

Example a string like below:

"ODBC;DRIVER=SQL Server; " & "SEMMER\SQLExpress;DATABASE=Finance;Trusted_Connection=Yes"

[former_member751591]

Thank you for visiting SAP Community to get answers to your questions. Since you're asking a question here for the first time, I recommend that you familiarize yourself with Community Q&A , as it provides tips for preparing questions that draw responses from our members.

For example, you can:

- outline what steps you took to find answers (and why they weren't helpful)

- share screenshots of what you've seen/done

- make sure you've applied the appropriate tags

- use a more descriptive subject line.

The more details you provide, the more likely it is that members will be able to respond. Feel free to also take our Q&A tutorial Q&A tutorial

Should you wish, you can revise your question by selecting Actions, then Edit.

By adding a picture to your Profile you encourage readers to respond.