ODBC Database - Save Password

[KEKeogh]

OK So I setup linked tables using an ODBC Database and everything is working perfect!!!

But when I set it up I forgot to click "Save Password" and every time I open the database it asks me for it.

How can I get it to save the password after the fact?

Thanks
Kathie

 

[Minty]

Go to the windows ODBC set up and edit the configuration there.

 

[AccessBlaster]

Hi Kathie,

I don't ever recall seeing a save "password tic box" on the ODBC logon page. It usually offers to use Windows authentication or SQl authentication. In any case I wouldn't want a casual user to logon and start monkey around in my tables.

You can always reconfigure your ODBC setup or just delete it, and start again. It only a pain the first time...

 

[arnelgp]

use the tabledef object to view and edit the the connection string of that table/tables.

dim db as dao.database
dim td as dao.tabledef
dim strConnect as string
set db=currentdb
set td=db.Tabledefs("thelinkedTableName")
strConnect = td.Connect
'modify strConnect add pwd=123password (the correct password)
td.Connect = strConnect
set td=nothing

 

[KEKeogh]

There was a Save Password tic box when you added the ODBC Database tables into Access 2013. I just re-added the tables making sure to check that box this time.

Just had to make sure I put all the relationships back they way they were.