J
jenny
I have an application written in Access. And one of the functions is to link
tables from SQL Server to this application using the following method:
DoCmd.TransferDatabase acLink, ..., False
The "False" value here is to make the application not save the login and
password for an ODBC database in the connection string for a linked table
during the link process. so that user is forced to login each time he opens
the table.
My question is :
If I want to mimic this function and do it manually using the "Link
tables..." in Access, how can I do it? -- Here is what I do: When I choose a
table, I purposely not to check the "Save Password" option. But it does not
seem to work the same way as what the "TransferDatabase" works with the
"False" option as I described above.
If anyone can help, I would appreciate it.
tables from SQL Server to this application using the following method:
DoCmd.TransferDatabase acLink, ..., False
The "False" value here is to make the application not save the login and
password for an ODBC database in the connection string for a linked table
during the link process. so that user is forced to login each time he opens
the table.
My question is :
If I want to mimic this function and do it manually using the "Link
tables..." in Access, how can I do it? -- Here is what I do: When I choose a
table, I purposely not to check the "Save Password" option. But it does not
seem to work the same way as what the "TransferDatabase" works with the
"False" option as I described above.
If anyone can help, I would appreciate it.