Removing the Database Password

To remove a database password, replace the existing password with Null. The password can be removed by using the ALTER DATABASE PASSWORD statement as illustrated in the preceding section. When the database is secured with a password, you will need to use the Jet OLEDB:Database Password property to specify the password to open the database. This is a Microsoft Jet 4.0 OLE DB Provider-specific property of the Connection object. The following procedure shows how to remove the password "secret" from the Sites.mdb database that was set by the SetDbPassword procedure in Hands-On 22-1.

0 0

Post a comment