Prevent ODBC password

[wichtel]

How can I prevent Access to ask the password each time I import a table with ODBC? I used this code to get the tables:

DoCmd.TransferDatabase acImport, "ODBC Database", "ODBC;Database=dora;UID=test;PW=test;DSN=dora", acTable, Me.Type, "pb6", False[/COLOR][/COLOR][/COLOR]

Thanks for your help!
Tim

 

[snotmare]

Hello wichtel!

Are you talking about masking the password in your code? I don't think that the password can be accessed after you import a table.

Also, do you have to import rather than just connect?

Thanks

He who has knowledge spares his words, and a man of understanding is of a calm spirit. Even a fool is counted wise when he holds his peace; when he shuts his lips, he is considered perceptive. - King Solomon