table not found error, but it does exist.

  • Thread starter Thread starter James
  • Start date Start date
J

James

how come i randomly get an error message saying table not found (exact error
message is pasted at bottom of this post). I get this error when trying to
perform a select statment with ADO in visual basic 6 on windows xp to a
remote access 97 .mdb via oledb.

Error #: -2147217865 Description: The Microsoft Jet database engine cannot
find the input table or query 'MyTableName'. Make sure it exists and that
its name is spelled correctly.
 
You positive you haven't mistyped the table name (leaving out embedded
blanks, for instance) or the database name?
 
nope, it will work for about two weeks and then do this and crash (because i
didn't put an error trap if there is no table of course).


Douglas J. Steele said:
You positive you haven't mistyped the table name (leaving out embedded
blanks, for instance) or the database name?
Click to expand...
 
Back
Top