Anyone?
Jacek
2018-06-01 14:21 GMT+02:00 Łukasz Jarych <jaryszek@xxxxxxxxx>:
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
