HOW ACCESS OLEDB 4.0 PASSWORD PROTECTED

[Edilson]

I NEED TO ACCESS A MDB ( ACCESS 2000) PASSWORD PROTECTED ( I DO HEVE THE PASSWORD ).. BUT IT DOEN'T WORK LIKE THE 3.51 ..

I HAVE THIS CONNECTION : Conn1.Open "PROVIDER=MSDataShape;Data PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Tour\Tour.mdb;"

[Jimbob]

You need to also specify the following in your connectionstring

Jet OLEDB:System Database
ID
Password

[Gary.Lowe]

try this

cn.open ("Provider=Microsoft.Jet.OLEDB.4.0;" & _
        "Data Source=C:\Tour\Tour.mdb;" & _
        "Jet OLEDB:Database Password=Password;")