Setting new database password with ADO

[DeltaTech]

Hello everyone
I am using ADO and Access database. For security reasons, I would like to reset the database password through code periodically.
IN DAO it was as simple as db.Newpassword(oldPassword, newPassword), but for the life of me, I cannot seem to find a similar method in ADO.
Anyone out there who knows how I can do this?
Much appreciated.

 

[BiggerBrother]

try this link:

http://support.microsoft.com/?kbid=304915

BB

 

[DeltaTech]

Thanks BiggerBrother.
For those of you who may be interested, here is a sample code:

Private cn As ADODB.Connection
Private strSQL as string

Set cn = New ADODB.Connection
cn.Mode = adModeShareExclusive
cn.Open "Provider=Microsoft.jet.OLEDB.4.0;Data Source='C:\whatever.mdb'"
strSQL = "ALTER Database Password " & "newpassword" & "``"
cn.Execute strSQL

Note that the database must be opened in exclusive mode.

 

[BiggerBrother]

You're welcome. Glad it helped.

BB