Connect with protected MS Access database

[nasreen]

Hi all,

How can I connect with MS Access Database protected with username and password.

When I try to do so an error occured,

Help needed

Nasreen

[randem]

nasreen,

An error occurred? An answer occured also... So show us yours and we'll show you ours.

[moinkhan]

Hi all,

How can I connect with MS Access Database protected with username and password.

When I try to do so an error occured,

Help needed

Nasreen

Dim myCon As New Connection
Dim x As New Recordset
 
Private Sub Form_Load()
myCon.ConnectionString = "Provider = Microsoft.Jet.OLEDB.4.0;Data Source=c:\db1.mdb;" & "Jet OLEDB:Database Password=moin;"
myCon.Open
Set x = myCon.Execute("Select * from Table1")
Text1.Text = x.Fields(1).Value
 
End Sub

[dee-u]

How can I connect with MS Access Database protected with username and password.

How did you protect the database with a Username? Through the User and Group accounts?

[kulitag]

this might help
try