I have an Access 2000 dB that connects to SQL tables using an ODBC
connection.
When creating the connection I checked the option to 'Save PAssword'.
Where
is this password stored? and Is it encrypted? Thanks
If you made a File DSN, then a something.dsn file was created using the DSN
name that you gave it. You can search for this file with the Windows
Explorer (I forget where it lives) and this file will be stored as plain
text.
If you made a System or User DSN, I believe it gets stored in the system
registry. If it's a System DSN, then I think it gets saved in
HKEY_LOCAL_MACHINE\big\long\path. If it's a User DSN, then I think it gets
saved in HKEY_CURRENT_USER\big\long\path and is only visible to the Windows
user account that created it.
In any case, I don't think the ODBC password is encrypted in any way.
If you are connecting to SQL Server tables, you can use "Windows Integrated
Authentication", wherein, Access contacts a Domain Controller to find out if
it has rights to the SQL Server, and also contacts SQL Server to find out if
the user is allowed to touch the server. It is my personal opinion that
this way is best. When in doubt, ask the DBA or Server Administrator that's
in charge of the SQL Server and/or the Windows Domain.
--
Peace & happy computing,
Mike Labosh, MCSD MCT
Owner, vbSensei.Com
"Escriba coda ergo sum." -- vbSensei
