I have an Access database consisting of tables linked to Postgres database tables via an ODBC DSN. However, everytime I open the Access database I have to enter a user and password to get to the tables. I would like not to have to do this, as this is not a security risk for what I'm doing. I supplied the user and password when I created the DSN but that didn't seem to amount to much.
In short, I would like to know how to setup an ODBC DSN such that I do not have to enter a password everytime I open the database.