Dear,
I am not using any DAO objects for my application. I have included the DAO references for my project. i am creating a database object.

dim db as database
dim rs as recordset
private sub form_load()
set db = opendatabase(path,false,false)
set rs = db.openrecordset("table",options)
end sub




This code works fine if my database is not set a password. But if it is set a password it says odbc call failed. I have used workspace too.
can some one give me a solution along with an example.
Thank You