Connect with protected MS Access database

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

nasreen,

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

Quote:

---

Originally Posted by 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

---

VB Code:

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

Quote:

---

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?

this might help
try