MS Access Not Responding Make Table Qry
in [Queries]
|
Prev: Date query
Next: Nulls making a mess!
From: Laura1 via AccessMonster.com on 21 Jan 2010 13:48 I am running a simple make table qry and access 07 seems to hang. If I run the same qry as a select qry it runs fine. Have compacted and repaired and used jetcomp, nothing is making it work. Volume of records is small. Any ideas? Thanks -- Message posted via http://www.accessmonster.com
From: Jerry Whittle on 21 Jan 2010 14:35 When it hangs, do an Alt + Tab and see what applications are running in the background. It's possible that an error message requiring a decision by you is hiding behind the Access window. A Windows button + M might also show the error message. -- Jerry Whittle, Microsoft Access MVP Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. "Laura1 via AccessMonster.com" wrote: > I am running a simple make table qry and access 07 seems to hang. If I run > the same qry as a select qry it runs fine. Have compacted and repaired and > used jetcomp, nothing is making it work. > > Volume of records is small. Any ideas? Thanks > > -- > Message posted via http://www.accessmonster.com > > . >
From: Laura1 via AccessMonster.com on 21 Jan 2010 14:51 Thanks, there is nothing the way I see it not responding is when I go to the task mgr. This is so frustrating. Jerry Whittle wrote: >When it hangs, do an Alt + Tab and see what applications are running in the >background. It's possible that an error message requiring a decision by you >is hiding behind the Access window. > >A Windows button + M might also show the error message. >> I am running a simple make table qry and access 07 seems to hang. If I run >> the same qry as a select qry it runs fine. Have compacted and repaired and >> used jetcomp, nothing is making it work. >> >> Volume of records is small. Any ideas? Thanks -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-queries/201001/1
From: Jerry Whittle on 21 Jan 2010 16:31 I don't trust the Not Responding in Task Manager. Same goes when you check Processes there and see 90% to 100% cpu being used by Access. Maybe post the SQL for the Select and Make Table queries. That might provide a hint to the problem. -- Jerry Whittle, Microsoft Access MVP Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. "Laura1 via AccessMonster.com" wrote: > Thanks, there is nothing the way I see it not responding is when I go to the > task mgr. This is so frustrating. > > > Jerry Whittle wrote: > >When it hangs, do an Alt + Tab and see what applications are running in the > >background. It's possible that an error message requiring a decision by you > >is hiding behind the Access window. > > > >A Windows button + M might also show the error message. > >> I am running a simple make table qry and access 07 seems to hang. If I run > >> the same qry as a select qry it runs fine. Have compacted and repaired and > >> used jetcomp, nothing is making it work. > >> > >> Volume of records is small. Any ideas? Thanks > > -- > Message posted via AccessMonster.com > http://www.accessmonster.com/Uwe/Forums.aspx/access-queries/201001/1 > > . >
From: Laura1 via AccessMonster.com on 21 Jan 2010 17:56
Here it is... As you can see it is VERY elementary...not sure why it works in select but not make table.. SELECT MIS_ASSOCIATE_HIST.ASSOC_ID, MIS_ASSOCIATE_HIST.YYYYMM, MIS_ASSOCIATE_HIST.FIRST_NAME, MIS_ASSOCIATE_HIST.MIDDLE_NAME, MIS_ASSOCIATE_HIST.LAST_NAME, MIS_ASSOCIATE_HIST.STATUS_CODE, MIS_ASSOCIATE_HIST.JOB_DESC, MIS_ASSOCIATE_HIST.HIERARCHY_POINT_CODE, MIS_ASSOCIATE_HIST.LEVEL_9_HIERARCHY_DESC, MIS_ASSOCIATE_HIST.PERSON_NUMBER, MIS_ASSOCIATE_HIST.JOB_CODE INTO Tbl_MIS_ASSOCIATE_HISTORY FROM MIS_ASSOCIATE_HIST WHERE (((MIS_ASSOCIATE_HIST.YYYYMM)=[Prior Month Date YYYYMM]) AND ( (MIS_ASSOCIATE_HIST.STATUS_CODE)="A")); Jerry Whittle wrote: >I don't trust the Not Responding in Task Manager. Same goes when you check >Processes there and see 90% to 100% cpu being used by Access. > >Maybe post the SQL for the Select and Make Table queries. That might provide >a hint to the problem. >> Thanks, there is nothing the way I see it not responding is when I go to the >> task mgr. This is so frustrating. >[quoted text clipped - 9 lines] >> >> >> >> Volume of records is small. Any ideas? Thanks -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-queries/201001/1 |