Help ==> DataReprot + Password Protected Database (Urgent)

[Naveed_Cn]

Hi Everyone
I m trying to open password protected Database for Data Report applying the following Code in Command Button1.

Dim CN As ADODB.Connection
Dim RS As ADODB.Recordset
Set CN = New ADODB.Connection
Set RS = New ADODB.Recordset
CN.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0" & _
";Data Source =" & App.Path & ".\MyDataBase.mdb"

CN.Open
Set RS = CN.Execute("Select * From Tabel1 Where Name ='" & txtName.Text & "'")
Set DataReprot1.DataSource = RS

DataReprot1.Show

But its showing error please, anyone tell me how can I set the connection for password protected Database.

[QVeen72]

Hi,

open password protected database like this :

CN.ConnectionString = _
"Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source="& App.Path & _
"\MyDataBase.mdb" & ";" & _
"Jet OLEDB:Database Password=MyPWd" 

    CN.Open

Regards
Veena

[suneel kar]

hi veena
our company has a passwor protected database.can we open tthat database.
regards
suneel

Hi,

open password protected database like this :

CN.ConnectionString = _
"Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source="& App.Path & _
"\MyDataBase.mdb" & ";" & _
"Jet OLEDB:Database Password=MyPWd" 

    CN.Open

Regards
Veena

[QVeen72]

Hi,

If it is in Access, and if u know the Password then u can open it with the above code..

Regards
Veena

[suneel kar]

hi veeeeeeee
if password is known anyone can access the databae. without password is it possible
regards
suneel

Hi,

If it is in Access, and if u know the Password then u can open it with the above code..

Regards
Veena

[suneel kar]

hi veena
and wt if i ddont know the passwod
regaards
suneel

[QVeen72]

Hi,

Try for some Password Breakers...

I gave the code In view of a "Developer"

Not As A "Hacker"..... :)--Vee