MS Access Not Responding Make Table Qry
Laura1 via AccessMonster.com
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
Jerry Whittle
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:
> .
>
Laura1 via AccessMonster.com
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
Jerry Whittle
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:
> .
>
Laura1 via AccessMonster.com
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]
KARL DEWEY
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:
> .
>
Laura1 via AccessMonster.com
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
Jerry Whittle
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:
> .
>
Laura1 via AccessMonster.com
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]
David W. Fenton
news:a27448bfe2088@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/
Laura1 via AccessMonster.com
some how fixed it.
Thanks again!
David W. Fenton 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 you run the SELECT and hit the last record button? How long
>does it take before you get a recordcount?
>
--