skrillalax
New Member
- Joined
- Dec 11, 2012
- Messages
- 1
Hello,
I have a make table query that uses 5 tables and one query. I have an issue with one of the source tables for this make table query. The query freezes when attempting to run it. The only way to fix it, is to go into design view, delete the source table (only has 2 fields in it) and then re-add the table. Once the table is re-added, the query works as expected (only once). As soon as I try to run it again, it freezes until I remove and re-add the source table. I cannot figure out why this is. Any advise will be much appreciated! Thank you for your time!
I have a make table query that uses 5 tables and one query. I have an issue with one of the source tables for this make table query. The query freezes when attempting to run it. The only way to fix it, is to go into design view, delete the source table (only has 2 fields in it) and then re-add the table. Once the table is re-added, the query works as expected (only once). As soon as I try to run it again, it freezes until I remove and re-add the source table. I cannot figure out why this is. Any advise will be much appreciated! Thank you for your time!