I have searched and studied solutions for similar problems on the net but could not solve this one..
Here is the code I am trying to get working:

Private Sub Form_Load()

Adodc1.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path() & "\Database.mdb;Persist Security Info=true;User ID = Admin; Password =;Database Password = mypassword"

Adodc1.CommandType = adCmdTable
Adodc1.RecordSource = "sp_query1"
Set DataGrid1.DataSource = Adodc1
StatusBar1.Panels(1).Text = "Number of Records: " & Adodc1.Recordset.RecordCount

End Sub

If I run this without a password for the database.. it runs properly...
using a password is getting me this problem..

Any help is appreciated.