Re: VBA to connect to postgresql from MS Access

Anyone?

Jacek

2018-06-01 14:21 GMT+02:00 Łukasz Jarych <jaryszek(at)gmail(dot)com>:

> Hi Guys,
>
> When i have linked table based on DSN odbc connection to postgresql ,
> i am going to :
>
> VBA editor, in immediate window inputing:
>
> ?CurrentDb.TableDefs("TableName").Connect
> i have very strange connection string:
>
> ODBC;DSN=PostgreSQL35W;DATABASE=AccessTest;SERVER=localhost;PORT=5432;*CA=d;A7=100;B0=255;B1=8190;BI=0;C2=;CX=1c305008b;A1=7.4*
>>
>>
>>
> When i was searching code for this in internet i found only:
>
> DRIVER={PostgreSQL Unicode(x64)};DATABASE=AccessTest;SERVER=localhost;PORT=5432;UID=postgres;PWD=1234;"
>>
>> but this is not working, why? I do not know what these CA, BO, BI strange
> paramaters.
>
> I want to use VBA to relink all tables and use DSN less connection string.
>
> Please help,
> Best,
> Jacek
>
>>
>
>