Access 2007 - DoCmd.TransferDatabase not saving UID and PW

[Hal Levy]

I run something like the following:

DoCmd.TransferDatabase acLink, "ODBC Database",
"ODBC;Description=myDatabase;DRIVER=SQL
Server;SERVER=PSQL;UID=user;PWD=password;APP=Microsoft Data Access
Components;DATABASE=myDatabase", acTable, "tblMyTable", "dbo_tblMyTable"


what I find in the mSysObjects table is


Description=myDatabase;DRIVER=SQL Server;SERVER=PSQL;APP=Microsoft Data
Access Components;DATABASE=myDatabase



as you can see the UID and PWD were removed. I need them there... as
they are for all the other tables that are linked. However anything I
am adding now won't save the UID and PW.

How can I get it to save the information in the Connect column like it
has for all the others?

Thanks!

 

[Hal Levy]

I continue to work on this issue. I notice the old linked tables have a
"Flags" column of 537919488 while the new ones I am creating are
1052673. I have been unable to find any explanation as to what the
537919488 Flags stand for or how to use it. I am still befuddled as to
how to get a Connect string to stop filtering out the UID PW that's
being put into it.

 

[Hal Levy]

FINALLY found the answer...

http://groups.google.com/group/comp.databases.ms-access/browse_thread/thread/3db4fcf05e2ba1b1