Jet database engine could not find the object 'Expr...'

[Orgil]

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

 

[Paul Clement]

¤ 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)

 

[Orgil]

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.

 

[Paul Clement]

¤ > 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)