Use Vba To Query Data From A Password Protect Access Database

I have an excel file that imports data from an access database. Now the user wants the database password protected I edited my code to include the line "user ID=admin;password=risk;" but I'm getting an error message stating: "Cannot start your application. The workgroup information file is missing or opened exclusively by another user."

I'm bothered because I did not create a workgroup information file. I just want a password on the database I did not create users and groups.

Note this code works fine without the password protection and the added line.

My

Sub Update_Click()

Dim rsData As ADODB.Recordset
Dim szConnect As String
Dim szSQL As String

szConnect = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source= C: est.mdb;" & _
"user ID=admin;password=risk;"

szSQL = "SELECT * from data"

Set rsData = New ADODB.Recordset

rsData.Open szSQL, szConnect, adOpenForwardOnly, adLockReadOnly, adCmdText