MS jet db engine could not find object

[Guest]

The message 'Microsoft Jet database engine could not find the object
'dbo_uXXXXX'. Make sure the object exists and that you spell its name and the
path name correctly.' is being displayed on one associates machine and not on
another. Both have the identical ODBC connection and security. Any ideas on
how to resolve this issue will be greatly appreciated!

Thanks, Jani

 

[Guest]

Is this dbo_uXXXXX not found when a pass through query is executed? if so,
you might need to change the "dbo_" to "dbo." where ever the table name is
referenced in the SQL statement.

 

[Charles Calvert]

The message 'Microsoft Jet database engine could not find the object
'dbo_uXXXXX'. Make sure the object exists and that you spell its name and the
path name correctly.' is being displayed on one associates machine and not on
another. Both have the identical ODBC connection and security. Any ideas on
how to resolve this issue will be greatly appreciated!

Go to the affected PC and verify that a table by that name is listed
in the table collection. If so, try to open it and see what happens.
I suspect that you'll get an error that is more useful.

 

[Guest]

Thanks for the advice - I will try and see if successful otherwise will post
again to this same record. Jani