Re: [MS_AccessPros] Make-Table Query hangs

 

Dave-

It might help to see the SQL of your query.  Also, it might be faster to use an Append query into an existing table that has indexes predefined rather than try to create a new table each time with Make Table.  The table created by Make Table will never have indexes to speed things up.  The only drawback using an existing table is you'll have to clear it with DELETE * before running your Append.

John Viescas, Author

Microsoft Access 2010 Inside Out

Microsoft Access 2007 Inside Out

Microsoft Access 2003 Inside Out

Building Microsoft Access Applications 

SQL Queries for Mere Mortals 

http://www.viescas.com/ 

(Paris, France)

On Dec 19, 2013, at 1:50 AM, <davewi11@yahoo.co.uk> <davewi11@yahoo.co.uk> wrote:

I am using Access 2003 on XP. I have a complex query which generates rows correctly, but I haven't managed to get to a final one as yet. When I try to use a Make-Table query to make the results permanent, the progress bar goes as expected, but when it reaches the end, the file size of the database starts increasing (viewed in Windows Explorer). After a while, the file is still being continually modified, CPU still 100% occupied, but the filesize remains constant at about double the original, and I never get the dialog asking to paste nnnn records. The screen is frozen.

 

However, activity stops when I press CtrlBreak, and I can then "Compact & Repair" to restore the original filesize.

 

What might be the problem?. There is no obvious HDD activity occurring, and there are no other unusual tasks running as far as I know. I get the same on two PCs.

 

Is there a way of limiting the number of rows a query generates?

__._,_.___

Reply via web post

Reply to sender

Reply to group

Start a New Topic

Messages in this topic (2)

Recent Activity:

• New Members 1

Visit Your Group

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use • Send us Feedback

.

__,_._,___