Change linked table source + password using code 1

[OldBird]

Hi, Thanks to the following thread:

http://www.tek-tips.com/viewthread.cfm?qid=246861&page=1

I have managed to write some code to change the source of a linked table.
BUT the table that I am linking to is in a password protected database - does anyone know how or where in the code I can prompt the user for the password (or hardcode the password in)?
I am getting the error:
Function: fRefreshLinks
Description: Not a valid password
Error#: 3031

Any help appreciated - Thanks

 

[JoeAtWork]

Look up Access in

http://www.ConnectionStrings.com,

look for ODBC connection with Workgroup/Security file.

 

[OldBird]

Thanks very much JoeAtWork - a very useful link.