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").Connecti 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.4When 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
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
DRIVER={PostgreSQL Unicode(x64)};DATABASE=AccessTest;SERVER=localhost;PORT=5432;UID=postgres;PWD=1234;"
pgsql-general by date:
Соглашаюсь с условиями обработки персональных данных