Access 2007 - DoCmd.TransferDatabase not saving UID and PW


Hal Levy

I run something like the following:

DoCmd.TransferDatabase acLink, "ODBC Database",
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?


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.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question