Board index » DotNet » Jet database engine could not find the object 'Expr...'

DotNet335
I have been connecting to MS-Access database using Jet 4.0

from C#.NET. My application works finely on my computer on which I've

made the application.



But I observed a strange behavior. When I run my application on other

computer that is installed .NET Framework, I get the following error

"System.Data.OleDb.OleDbException: The Microsoft Jet

database engine could not find the object 'Expr1007'.

Make sure the object exists and that you spell its name

and the path name correctly.".



When I open Access mdb in the UI and paste the query string into the

SQL window of the query designer and executes it, I get no error, the

query results correct rows. I do this test on both other and my

computer.



What's the solution?



Thanks in advance



... Orgil


-

On Wed, 26 Sep 2007 01:54:56 -0700, Orgil <orgilhp@yahoo.com>wrote:



¤ I have been connecting to MS-Access database using Jet 4.0

¤ from C#.NET. My application works finely on my computer on which I've

¤ made the application.

¤

¤ But I observed a strange behavior. When I run my application on other

¤ computer that is installed .NET Framework, I get the following error

¤ "System.Data.OleDb.OleDbException: The Microsoft Jet

¤ database engine could not find the object 'Expr1007'.

¤ Make sure the object exists and that you spell its name

¤ and the path name correctly.".

¤

¤ When I open Access mdb in the UI and paste the query string into the

¤ SQL window of the query designer and executes it, I get no error, the

¤ query results correct rows. I do this test on both other and my

¤ computer.

¤

¤ What's the solution?

¤

¤ Thanks in advance



What does the query string look like?





Paul

~~~~

Microsoft MVP (Visual Basic)

-

The query string is very simple: "SELECT [colUsername], [colPassword]

FROM TblUsers".

This query is the first query to be executed of all queries of the

application.



I tried other queries, such as "SELECT [colName], [colDesc], [colDate]

FROM TblNotes WHERE [colID] = 1".



But all of these get same error "Jet database engine could not find

the object 'Expr...'" on other computer.



-

On Wed, 26 Sep 2007 20:36:52 -0700, Orgil <orgilhp@yahoo.com>wrote:



¤>What does the query string look like?

¤

¤ The query string is very simple: "SELECT [colUsername], [colPassword]

¤ FROM TblUsers".

¤ This query is the first query to be executed of all queries of the

¤ application.

¤

¤ I tried other queries, such as "SELECT [colName], [colDesc], [colDate]

¤ FROM TblNotes WHERE [colID] = 1".

¤

¤ But all of these get same error "Jet database engine could not find

¤ the object 'Expr...'" on other computer.



I don't see anything out of the ordinary here. I would try compacting the database on the machines

where the queries fail. I would also open the database on those machines and check to see if there

are any references listed as missing (Tools...References). Sometimes this can cause strange

behavior.





Paul

~~~~

Microsoft MVP (Visual Basic)

-