Imports DAO
Public Function ChangePassword(ByVal Database As String, ByVal NewPassword As String, ByVal OldPassword As String)
Dim DAOCONN As New DAO.DBEngine
Dim db As DAO.Database
db = DAOCONN.OpenDatabase(Database, True, False, ";pwd=" & OldPassword)
If Err.Number <> 0 Then Exit Function
db.NewPassword(OldPassword, NewPassword)
ChangePassword = Err.Number = 0
db.Close()
End Function

