Access A locked Database From VB 1

[schembri]

I've Got An Ms Access database that i wish to lock but when i lock it my vb programm does not open it.

the programm displays an error saying in valid password.

can any one tell me how can i supply a password to the database through vb coding

 

[CCLINT]

How are you opening it in VB?
ADO Adodc Data Control?
DAO Data1 Data Control?
ADO Connection Object?
DAO Database Object?

 

[schembri]

i'm using DAO Database Object to connect to the database.

 

[CCLINT]

Set MyDB = DBEngine(0).OpenDatabase(App.Path & "\" & App.EXEName & ".MDB", False, False, ";pwd=abc123&quot

You may instead need to use something like
";User=Admin;pwd=abc123"