Connection String vs Password [RESOLVED]

[g-mie]

Hi guys

Below is my current connection string code

Set db = New ADODB.Connection
    db.CursorLocation = adUseClient
    db.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\SPCPD_DATA\SPCPD.mdb;Persist Security Info=False"

I cannot access into database (MS-Acces) after I set password. The error msg are "Run-time error '2147217843 (80040ed)': Not a valid password."

What should I do? Need your advice guys.

TQ

[dglienna]

Try this:

db.Open ="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\somepath\mydb.mdb;Jet OLEDB:Database Password=MyDbPassword;"

Hope it helps!

from
http://www.connectionstrings.com/

[g-mie]

dglienna
Thank you. It's worked. Thanks again.