I can't connect Access 2000 with password!!!
data.connect ="MS Access;PWD=mypassword" -works with access97 but not access2000!!!
Pls Help!!!
Printable View
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.
Service Pack 5 installed.Quote:
Originally Posted by Pasvorto
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
You can disable (per posting) the smilies in your post by checking "Disable smilies in text"VB Code:
"Provider=Microsoft.Jet.OLEDB.4.0;" & _ "Data Source=database.mdb;Jet OLEDB:Database Password = 'password'"
under the Miscellaneous Options frame when replying to a thread.
:) <-- Disabled smilie
You are talking about ADO, but i'm using DAO.Quote:
Originally Posted by demotivater
Any way thnx.
p/s
Is there any boby knows how to connect ACCESS 2000 with password using "data.connect=..." ?