Make-Table Query doesn't respond

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a query that works fine when set as a a select query (it runs and
displays teh results ina datasheet view) but hangs up when it is set as a
make-table query (Access does not respond and I have to kill the task). What
would cause this and how do I fix the problem?
 
May be a permission issues. Possibly corruption. Repair and Compact, try
again.
 
I did repair and compact the DB with no change.

I can still access adn view the linked table directly by double clicking on
the linked table in the list of DB tables. A simple select query of the
same table also works as expected and displays the query results on screen .
It's just the make-table query that doesn't complete and causes Access to not
respond and hang.

Not sure where to go from here.
 
Back
Top