Hi , That would work as long as the user name and password used to login into > Access are also recognized by Postgres.
I created users in postgresql and connecting to database using windows username and common password. Thank you for help. Best, Luke 2018-06-21 15:33 GMT+02:00 Adrian Klaver <adrian.kla...@aklaver.com>: > On 06/21/2018 01:33 AM, Łukasz Jarych wrote: > >> Hi Guys, >> >> the best option here i think is to: >> >> 1. Create users login in Access >> 2. Use DSN-less odbc connection. >> 3. When user is login to Access i am taking password and using it in >> postgresql BE. >> > > That would work as long as the user name and password used to login into > Access are also recognized by Postgres. > > > >> Best, >> Luke >> > > > -- > Adrian Klaver > adrian.kla...@aklaver.com >