Make Table query gets ODBC Error

  • Thread starter Thread starter Robin Hughes
  • Start date Start date
R

Robin Hughes

Help! I am running an Access 2002 query to create a table
from an ODBC file on a AS400. I am running under Windows
98. I can open the linked table without a problem but when
I try to run the make table query from that table I
get "Estimated query processing time 63 exceeds limit 60
#666 and Error 3146 comes up if you press Help, which says
I may not be connected to the network. If that was true I
wouldn't be able to open the linked table at all. I also
have found that I can run this query under Windows xp. So
does anyone have any idea what happened to 98? This
database is an old database and it used to work a week
ago. Any help would be appreciated. Thanks Robin
 
It sounds like you're only 3 seconds off. Perhaps there is a way to raise
the limit from 60 to 65 or 120 would be even better.
 
Back
Top