DoCmd.TransferDatabase - how to remove stored logins

[Scion]

Hi,

The DoCmd.TransferDatabase method has an optional StoreLogin parameter that
allows the login ID and password to be stored. I want to clear out the
stored values - how do I do this? Where are they stored?

Also according to the help,

"The administrator of an ODBC database can disable the feature provided
by the saveloginid argument, requiring all users to enter the login ID and
password each time they connect to the ODBC database."

How is this done?

Thanks
Sc.

[Stefan]

Hi Scion,
if you open an ODBC linked table in designview and show the properties, than you'll see the complete ODBC connecton string.
E.g. here is the string for an Oracle ODBC driver:
ODBC;DSN=ABCDE;UID=####;PWD=####;DBQ=ORA9I;DBA=W;APA=T;EXC=F;FEN=T;QTO=T;FRC=10;FDL=10;LOB=T;RST=T;GDE=F;FRL=F;BAM=IfAllSuccessful;MTS=F;MDI=F;CSR=F;FWC=F;PFC=10;TLO=0;

When you delete the part "UID=...;PWD=...;" you'll prompted for userid and password when you open this table (or another table using the same DSN!)

grts
Stefan