Access 2007 - DoCmd.TransferDatabase not saving UID and PW

  • Thread starter Thread starter Hal Levy
  • Start date Start date
H

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!
 
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.
 
Back
Top