"Not Enough Space On Temporary Disk" From Make Table Query

[The Brown Growler]

Hi,

Would anyone please be able to let me know if there is a fix for a message I get when running a make table query.

The message is "Not Enough Space On Temporary Disk".

The make table query uses a union query as a data source and the union query is taking data from two tables in two other independant ms access databases.

The size of the ms access database before running the make table query is approx 7mb and the two records sets used by the union query are approx 2,000,000 records and 650,000.

Is the "Temporary Disk" referred to in the message a windows adjustable setting such as the pagefile on my C:\ drive ? Or, is it an ms access internal setting that may or may not be adjusted ?

Thx for any help.

Rgds
Growler

 

[DCrake]

The main problem, as I see it, with make table queries is that any field that is a text type field is given a length of 255 characters and with so many records if you have many text fields this is the main culprit. Can you not first create the table then use an append query instead? By defining the field structure first you can eleminate unneccessary field widths.

Also where are you creating the make table? is it locally in the front end or in a seperate linked mdb. Avoid using the local front end as this will cause bloating.

David

 

[The Brown Growler]

David,

Thanks for the reply and explanation, I had forgotten about the field size for the text fields and there were quite a lot of those, no wonder it failed.

I ended up using the append option as you suggested to create the table and got it to work OK that way.

Rgds
Growler