“Run-time error '3078': The Microsoft Jet database engine can't find the input table or query TableName”
After linking to a table in an external db, I am attempting to open a recordset using the simple code shown below:
When executing this statement I get the error message as shown above, even though the table DOES exist. I simply press F5 etc and then the code continues running, bizarrely!
The module (subroutine) where this problem occurs is part of a larger process (several subroutines), and when ran as part of this larger process, the error occurs. However, if I run the sub separately, it works perfectly. In the preceding sub, the table in question is being linked to, updated and then the link is being deleted as my code moves on to the next table. The problem must be caused by something in this preceding subroutine but I just can’t figure out what, as all this preceding sub is doing is linking to tables, updating them and deleting the links.
Any ideas?
This is slightly similar to my last query in that I’m encountering some weird and inexplicable issues, which is rather irritating to say the least!
After linking to a table in an external db, I am attempting to open a recordset using the simple code shown below:
Code:
[COLOR=black][COLOR=black]Set rst = currentdb.openrecordset(“SELECT * FROM TableName”)[/COLOR][/COLOR]
The module (subroutine) where this problem occurs is part of a larger process (several subroutines), and when ran as part of this larger process, the error occurs. However, if I run the sub separately, it works perfectly. In the preceding sub, the table in question is being linked to, updated and then the link is being deleted as my code moves on to the next table. The problem must be caused by something in this preceding subroutine but I just can’t figure out what, as all this preceding sub is doing is linking to tables, updating them and deleting the links.
Any ideas?
This is slightly similar to my last query in that I’m encountering some weird and inexplicable issues, which is rather irritating to say the least!