can't connect Access 2000!

I can't connect Access 2000 with password!!!

data.connect ="MS Access;PWD=mypassword" -works with access97 but not access2000!!!

Pls Help!!!

If I remember correctly, I had to put a Service Pack in VB6 before I could access ACCESS2000.

Quote:

---

Originally Posted by Pasvorto

If I remember correctly, I had to put a Service Pack in VB6 before I could access ACCESS2000.

---

Service Pack 5 installed.
And i can access Access2000, but if database file protected with password I can't do it!

VB Code:

"Provider=Microsoft.Jet.OLEDB.4.0;" & _
        "Data Source=database.mdb;Jet OLEDB : Database Password = 'password'"

Note - remove the spaces between the B and the colon, and the colong and the D in - OLEDB : Database
Forum was creating a smily if I remove them. IE: OLEDB:Database

VB Code:

"Provider=Microsoft.Jet.OLEDB.4.0;" & _
        "Data Source=database.mdb;Jet OLEDB:Database Password = 'password'"

You can disable (per posting) the smilies in your post by checking "Disable smilies in text"
under the Miscellaneous Options frame when replying to a thread.

:) <-- Disabled smilie

Quote:

---

Originally Posted by demotivater

VB Code:

"Provider=Microsoft.Jet.OLEDB.4.0;" & _
        "Data Source=database.mdb;Jet OLEDB : Database Password = 'password'"

---

You are talking about ADO, but i'm using DAO.
Any way thnx.

p/s
Is there any boby knows how to connect ACCESS 2000 with password using "data.connect=..." ?