I'm using Access 2010 64 bit
I need help in the connection string to my database. First I did this
Code:
Dim connector As ADODB.Connection
Dim rst As ADODB.Recordset
Set connector = New ADODB.Connection
connector.Open CurrentDb.TableDefs("MyInternetTable").Connect
But what's good for the table isn't good for VBA and I got datasource name not found even though the linked table found it
Then I tried this:
Code:
"ODBC;DRIVER={PostgreSQL35W} etc"
Because of this:
Which of course didn't work even though that thing is on every tab of the data source. Then I tried this:
and did this:
Code:
connector.Open "ODBC;DSN={PostGre};
But, I just don't get these connection strings. I dont' know what features are enabled by making these connection strings so difficult to work. I'd appreciate any help available. Thanks