MS Access Not Responding Make Table Qry

[Laura1 via AccessMonster.com]

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

 

[Jerry Whittle]

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.

 

[Laura1 via AccessMonster.com]

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]

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.

 

[Laura1 via AccessMonster.com]

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"));

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]

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.

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"));

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

--



.

 

[Laura1 via AccessMonster.com]

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!

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]

 

[Jerry Whittle]

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.

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"));

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

--



.

 

[Laura1 via AccessMonster.com]

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!

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]

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?

 

[Laura1 via AccessMonster.com]

Yes, it came back in seconds. There aren't a lot of records. Like I said, I
some how fixed it.

Thanks again!