table not found error, but it does exist.

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.
 
D

Douglas J. Steele

You positive you haven't mistyped the table name (leaving out embedded
blanks, for instance) or the database name?
 
J

James

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

error says table not found error, but it does exist. 10
Works with runsql but not with .Execute 8
ADO Errors -2147217865 0
Error "Could not save; currently locked by another user." 11
DH Query By Form 8
Can not find SQL table 1
Object Not Found 2
Macro - Condition Test to determine if a table exists 1

Top