MS Access Not Responding Make Table Qry
in [Queries]
|
Prev: Date query
Next: Nulls making a mess!
From: KARL DEWEY on 21 Jan 2010 19:19 Is your 07 screen showing a "Security Warning - Some content has been disabled" then a square with the word 'Options' in it? Click the square and then click on 'Enable this content' and 'OK'. -- Build a little, test a little. "Laura1 via AccessMonster.com" wrote: > 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 > > . >
From: Laura1 via AccessMonster.com on 21 Jan 2010 20:23 Nope, this really is a mystery....I have the security warning set not to ask in the options. SO that isn't it....Not really sure what it is...so frustrating! Thanks! KARL DEWEY wrote: >Is your 07 screen showing a "Security Warning - Some content has been >disabled" then a square with the word 'Options' in it? >Click the square and then click on 'Enable this content' and 'OK'. > >> Here it is... >> >[quoted text clipped - 21 lines] >> >> >> >> >> >> Volume of records is small. Any ideas? Thanks -- Message posted via http://www.accessmonster.com
From: Jerry Whittle on 22 Jan 2010 12:11 Dang. I thougth that Karl might have nailed it. Grasping at straws here: Make sure that there isn't already a Tbl_MIS_ASSOCIATE_HISTORY table. Try running it without the Where Clause / criteria. Make sure that your database file isn't close to the 2GB file size limit. Do a Compact and Repair. This could bring the file size down if that's even a problem and maybe fix an internal problem preventing the Make Table from working. Try creating a new database file and importing everything from it. Then run the query. Make sure that you have Read/Write/Create/Delete privileges to both the database file and the folder where it's located. (Really grasping as straws with this one). -- Jerry Whittle, Microsoft Access MVP Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. "Laura1 via AccessMonster.com" wrote: > 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 > > . >
From: Laura1 via AccessMonster.com on 22 Jan 2010 13:54 Thanks everyone!!!! I defraged my pc, and did all the things suggested below. Including rebooting my cable. It worked, but again, not really sure which of the 1000's things I did fixed it!! Thanks again, PC are great when they work...when they don't ARGH... Have a great weekend! Jerry Whittle wrote: >Dang. I thougth that Karl might have nailed it. > >Grasping at straws here: > >Make sure that there isn't already a Tbl_MIS_ASSOCIATE_HISTORY table. > >Try running it without the Where Clause / criteria. > >Make sure that your database file isn't close to the 2GB file size limit. > >Do a Compact and Repair. This could bring the file size down if that's even >a problem and maybe fix an internal problem preventing the Make Table from >working. > >Try creating a new database file and importing everything from it. Then run >the query. > >Make sure that you have Read/Write/Create/Delete privileges to both the >database file and the folder where it's located. (Really grasping as straws >with this one). >> Here it is... >> >[quoted text clipped - 21 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
From: David W. Fenton on 22 Jan 2010 17:21
"Laura1 via AccessMonster.com" <u31091(a)uwe> wrote in news:a27448bfe2088(a)uwe: > 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 you run the SELECT and hit the last record button? How long does it take before you get a recordcount? -- David W. Fenton http://www.dfenton.com/ usenet at dfenton dot com http://www.dfenton.com/DFA/ |