Error 3011 Jet Engine Could Not Find Object

[tmort]

I have a split Access database that is in A2000 format. I have a query by form in it that used to work. Now I am getting Error 3011, Microsoft Jet Database Engine could not find object...

When I run the debugger it highlights the last line listed below.

strFinalSQLStatement = strDefaultSQLString + " " + strSQLClause1 + " " + strSQLClause2 + " " + strSQLClause3 + " " + strSQLClause4 + " " + strSQLClause5 + " " + strSQLClause6 + " " + strSQLClause7 + " " + strSQLClause8 + " " + strOrderByClause


Me.child0.Form.RecordSource = strFinalSQLStatement

I get the same error with a number of earlier versions as well. I have also got a new computer and now have Office 2003 installed if this might have anything to do with it.

Anyone have any ideas?

Thanks in advance

[llkhoutx]

Your hiding the problem by not posting the value of "strFinalSQLStatement."

[KenHigg]

Should these be '&'s and not '+'s?

ken

[FLabrecque]

KenHigg: Both of them works.. although I would try it with "&" instead. If that doesn't work, post the value of each variable (not just strFinalSQLStatement).

Did you solve the problem of "the Microsoft jet database engine could not find the object"? I have had the same problem after installing a new hard disk. I am using the same Office 2003 software but cannot open any of my databases. Help!!!

[tmort]

Yes I solved the problem. I had cut and pasted the code somewhere along the line and didn't get it all. It was missing a couple of lines.