Solved

Run-time error '3078' The Microsoft jet database engine cannot find the input table or query

Posted on 2006-07-11
12
2,105 Views
Last Modified: 2008-01-09
Hello,

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

Luke

0
Comment
Question by:LuckyLuke57
12 Comments
 
LVL 65

Expert Comment

by:rockiroads
ID: 17081135
Can u double check the link to the Excel table? You may perhaps need to recreate the link since its an upgrade


0
 
LVL 77

Expert Comment

by:peter57r
ID: 17081140
Hi LuckyLuke57,
Have you checked that you have a table with this name?

Pete
0
 
LVL 34

Expert Comment

by:jefftwilley
ID: 17081252
[Imported ABC MND3 (ruw)]   <----- It can't find this. It's either been renamed, you don't have permissions to it anymore, or like Rocki said, the link needs re-linking.  You may also check permissions on this spreadsheet to make sure you CAN still link to it.
J
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 38

Expert Comment

by:Jim P.
ID: 17081272
Is this a linked excel table?  

Part of SP2 was to disable linked Excel table manipulation because of a lawsuit.

http://www.theregister.co.uk/2006/02/07/microsoft_office_access_infringement/
0
 
LVL 10

Author Comment

by:LuckyLuke57
ID: 17081623
jimpen,

It is indeed a linked Excel table.

But I can't revert to a situation before SP2, so is there a work-around?

Thanks,

Luke

0
 
LVL 38

Accepted Solution

by:
Jim P. earned 500 total points
ID: 17081684
You can still do straight imports and export in excel format, but you can't do an append query to an excel table.

VBA Command:
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "MyTableName", _
        "C:\MyPath\MyFileName.xls", True
0
 
LVL 39

Expert Comment

by:stevbe
ID: 17081833
Are you adding records from excel into access or the other way around?

if you really need to append then you can use Excel automation ... open the existing excel file, go to the last row of the excel worksheet, open a recordset of the data you want to append and then loop through the recordset adding each record to the spreadsheet.
0
 
LVL 10

Author Comment

by:LuckyLuke57
ID: 17082101
I have an application in Access, with a form with a lot of buttons.
When I click on one button, it has to import data from Excel.

And then I come via the debugger in the code

DoCmd.RunSQL "SELECT * INTO [Imported ABC (ruw)] FROM [Imported ABC MND3 (ruw)];"

and with the above errormessage.

I know the direct link is forbidden, and I am willing to test the work-around from jimpen, but because I don't know a lot of Access and his SQL-commands and VBA, I don't know how to substitute the suggestion of jimpen into my problematic code.

Has it to become something like

' this replaces the direct link
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "Imported GOR MND1 (ruw)", _
        "C:\MyPath\MyFileName.xls", True
' and the old command must work
DoCmd.RunSQL "SELECT * INTO [Imported ABC (ruw)] FROM [Imported ABC MND3 (ruw)];"

OR is it

' this replaces the direct link
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "[Imported GOR MND1 (ruw)]", _
        "C:\MyPath\MyFileName.xls", True
' and the old command must work
DoCmd.RunSQL "SELECT * INTO [Imported ABC (ruw)] FROM [Imported ABC MND3 (ruw)];"

Luke
0
 
LVL 38

Expert Comment

by:Jim P.
ID: 17082280
Which of these your linked excel table? And which way are you trying to take the data -- import or export to the excel spreadsheet?

[Imported ABC (ruw)]
[Imported ABC MND3 (ruw)]
0
 
LVL 10

Author Comment

by:LuckyLuke57
ID: 17082419
VERY GOOD QUESTION
Indeed, it can be an export to excel, which is giving the problem or an import from excel.
Because I am beginning to investigate this problem, I have to ask to the people who use the application.
But they went home already (I am in Europe), so I come back to this within 16 hours.

Thanks a lot for the moment...
0
 
LVL 10

Author Comment

by:LuckyLuke57
ID: 17089037
Hello guys,

The guy with the problem application went on vacation, so I can't ask more info.
The work-around of jimpen helped:

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "ABC Export", ABC_Output_Path + ABC_OutputFile_MND3, True

Thanks,

Luke
0
 
LVL 38

Expert Comment

by:Jim P.
ID: 17089670
Glad to be of assistance. May all your days get brighter and brighter.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

685 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question