database password inaccessible from ADO?

[Jack White]

I am experimenting with database passwords in Access 2000 and see that it is
impossible to determine the password once the user authenticates
successfully as far as ADO is concerned. I need the password in order to
establish a shaped ADO recordset to the database in one my forms. I tried
accessing the password after successful autentication by querying both
CurrentDB.Properties("Password") or
CurrentProject.Connection.Properties("Password"). However both properties
return a null string instead of the database password.

How can I get the database password without prompting the user for it a
second time so that I can open a shaped recordset?

 

[Lynn Trapp]

There is code floating around the internet that will tell you how to extract
a database password, but I'm not sure anyone has developed a way to make it
work with Access 2000 yet. If I were you I would implement user level
security instead. See the Security FAQ link below.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Security FAQ: http://support.microsoft.com/support/access/content/secfaq.asp