Unable to resolve 2147217865 (Invalid object name) Error

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Adding a file to a 2nd PC. Works on my PC (development) and on the live PC.
An SQL statement within VB module, SELECT ..., has the error. Removed and
re-installed MS Office 2000 (same on all PCs). Re-installed MDAC 2.81.
Checked ADO/DAO Library checkboxes in Tools (same configuration - checked and
sequence). Only difference is working PCs are on Windows XP, the problem PC
is 2000 - it is older hardware and cannot run XP.

Any suggestions to resolve this?
 
EdAROC said:
Adding a file to a 2nd PC. Works on my PC (development) and on the
live PC. An SQL statement within VB module, SELECT ..., has the
error. Removed and re-installed MS Office 2000 (same on all PCs).
Re-installed MDAC 2.81. Checked ADO/DAO Library checkboxes in Tools
(same configuration - checked and sequence). Only difference is
working PCs are on Windows XP, the problem PC is 2000 - it is older
hardware and cannot run XP.

Any suggestions to resolve this?
Click to expand...

Could you show the code involved, and indicate what line of code is
actually raising the error?
 
hi,
Adding a file to a 2nd PC. Works on my PC (development) and on the live PC.
An SQL statement within VB module, SELECT ..., has the error. Removed and
re-installed MS Office 2000 (same on all PCs). Re-installed MDAC 2.81.
Checked ADO/DAO Library checkboxes in Tools (same configuration - checked and
sequence). Only difference is working PCs are on Windows XP, the problem PC
is 2000 - it is older hardware and cannot run XP.
Click to expand...
Are you using Access or VBA functions in your SQL like Left() or Nz()?
When yes, check the references, they may be broken.

Are you using With blocks with OLE automation? Is the Ole server still
active?

Has the failing PC the same language and country settings?


mfG
--> stefan <--
 
We discovered the problem. The ODBC connection configuration was not correct,
The default database was not pointing to the correct one.

Thanks for your replies.
 
Back
Top