VB6: what is the likely cause of Error 3078 " ... Jet database engine cannot find the input table or query ... "
views:
44answers:
2or someone was in your jet, eating your lap-tables
pst
2010-06-25 03:01:38
@slaks: problem is intermittent - not consistent with a typo in any SQL.
Craig Johnston
2010-06-25 04:18:17
I've seen this in programs that cobble SQL together on the fly in several parts of the program. Some code paths will result in a clean query while others lead to a fragmentary result that produces syntax errors or this sort of error.
Bob Riemersma
2010-06-26 17:32:28
+1
A:
Try checking the connection and checking the database for corruption, that is, back up and then compact and repair. You might also like to read this article on corruption
Remou
2010-06-25 07:01:05