Change database password with JET 4.0 OLEDB Provider

[mmcperri]

hi group

i need change the database (Access2000) password

how can i do?

thanks in advanced

[JC]

You can do it through a sql command:

-=-=-=-=-=-=-=-=-=-=-=-< SNIP FROM MSDN DOCS>=-=-=-=-=-=-=-=-=-=-=-=-=-

To set share-level security on a Jet database, use the ALTER DATABASE
statement to create, modify, or remove the database password. To use the
ALTER DATABASE statement, you must open the database in exclusive mode. The
general form of the ALTER DATABASE statement is as follows:

ALTER DATABASE PASSWORD NewPassword OldPassword

To set the database password for the first time, use the ALTER DATABASE
statement with the NULL keyword as the OldPassword parameter. Let's suppose
that we want to set the database password to "admin."

ALTER DATABASE
PASSWORD admin NULL

Note The ALTER DATABASE statement can be executed only through the Jet OLE
DB provider and ADO. It will return an error message if used through the
Access SQL View user interface or DAO.

To change the existing database password, use the ALTER DATABASE statement
with the appropriate passwords. Let's change the database password to
"administrator."

ALTER DATABASE
PASSWORD administrator admin

To remove a database password, use the ALTER DATABASE statement with the
NULL keyword as the NewPassword parameter. Let's remove the "administrator"
database password.

ALTER DATABASE
PASSWORD NULL administrator

For more information about using the ALTER DATABASE statement, type alter
database in the Office Assistant or on the Answer Wizard tab in the
Microsoft Access Help window, and then click Search.

=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
=-=-=-=-=-=-=-=-=-=-
"mmcperri" <mmcp...@teleline.es> wrote in message
news:ePxpVEoOAHA.292@cppssbbsa04...