Hi there,

I am stumped.

I am connecting to a database programatically using the data object on the form.

The Microsoft Jet database engine COULD not find the object . Make sure the object exists and that you spell its name and the path name correctly. (Error 3011)

I receive the above error witht the FOLLOWING syntax:

datAppeal.DatabaseName = App.Path & "\esltdb.mdb"
OpenDatabase App.Path & ("\esltdb.mdb")
datAppeal.RecordSource = "Select * from APPEAL where PERSNO like " & nPersno & ""

I open this form from my main form and only want to display data relevant to the id number from the main form.

Please tell me where am I GOING wrong.

Regards
ChristoI would think you need an object variable that represents the database object that you want to open.

Code: [Select]
Set database = workspace.OpenDatabase (dbname, options, read-only, CONNECT)


Also you might check what App.Path RESOLVES to. Personally I tend to use ADO, write the code inline, and use the MSHFlexGrid to display the data.

Hope this helps. Thanks it worked