Run-time error '3078' The Microsoft jet database engine cannot find the input table or query
Posted on 2006-07-11
I have to help somebody who has an application which worked well for a long time.
It is an Access application which links directly into an Excell table.
Since we installed SP2 for Office 2003, we get the following error:
Run-time error '3078' The Microsoft jet database engine cannot find the input table or query 'Imported ABC (ruw)"
And the debugger leads us to the following failing command:
DoCmd.RunSQL "SELECT * INTO [Imported ABC (ruw)] FROM [Imported ABC MND3 (ruw)];"
I don't think it is the sintax or the code, because it worked for several years every week...
Thanks a lot for any suggestion