Runtime error 3011 with import (1 Viewer)

[comicwizard]

Hello all,
I have a database with a piece of code that worked up to today.

My database connects to sql server. I use cross over queries to run the queries and the queries make temp tables. In the vb code I added one additional query between 2 other queries. then the import stopped working and gives a run time error 3011. The piece of code that no longers is this:

DoCmd.TransferDatabase acImport, "ODBC Database", "ODBC;DSN=SQL 2;Description=SQL2;DATABASE=tempdb;StatsLog_On=No;" & _
"DATABASE=tempdb", acTable, "##BiddingTOD", "LocalTOD"

The new query is extremely simple and shouldn't cause any troubles. It just updates 3 fields in a ##Temp table and the next query takes that table and does more things with it.

I haven't been able to figure this out.

 

[theDBguy]

Hi. What is error 3011? Can you post the new query and your VBA code? If you take out the new query, does everything work again?

 

[isladogs]

Error 3011:

The Microsoft Access database engine could not find the object '|'. Make sure the object exists and that you spell its name and the path name correctly. If '|' is not a local object, check your network connection or contact the server administrator.

So check out which item is missing