ODBC Sybase connection in access keeps requesting password!
Posted on 2010-01-06
I have a database tables linked to my access through ODBC. Everything's working fine, but whenever I close and open my access database, and try to access the linked table, it asks me for the linked database's password to re-connect. Is there any way around this? I would prefer to save the password so that access can access the database whenever it opens.
One thing I tried was to add a new string value for the password in the ODBC regedit. This seems to work when testing connecting in control panel as it doesn't prompt me for the password, but access still does! Any help would be great. Thanks.