Changing location of temp files - HELP!!!!

[Sandi]

Hello All,

I apologize if I'm in the wrong group for this message,
but really wasn't sure where it fit in. I am having a
problem when running a make table query. The query is
running against DB2 tables, and is pulling a huge amount
of data. The data is being built/stored in c:\temp while
it's building. The problem is, the c: drive on this
machine doesn't have much disk space. I need to change
the default setting for where Access puts it's temp files
to d:\temp. The d: drive on this machine has much more
room than the c: drive. I've searched on-line help and
the knowledge base, but can't seem to find any information
on this. Is it even possible to do? Is it something that
is done when Access is installed? This is a critical
problem, as this is a database that will be going into
production within the next month. Any help/advice would
be greatly appreciated!

Thanking you in advance for your help!

Sandi

 

[Tony Toews]

I apologize if I'm in the wrong group for this message,
but really wasn't sure where it fit in. I am having a
problem when running a make table query. The query is
running against DB2 tables, and is pulling a huge amount
of data. The data is being built/stored in c:\temp while
it's building. The problem is, the c: drive on this
machine doesn't have much disk space. I need to change
the default setting for where Access puts it's temp files
to d:\temp. The d: drive on this machine has much more
room than the c: drive. I've searched on-line help and
the knowledge base, but can't seem to find any information
on this. Is it even possible to do?

This has been requested a number of times in the newsgroups and I've
never seen any positive answers.

I wonder if it would make a difference if you created the table first
and then appended the records. I kinda doubt it but it might be worth
a try.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

 

[Sandi]

-----Original Message-----


This has been requested a number of times in the newsgroups and I've
never seen any positive answers.

I wonder if it would make a difference if you created the table first
and then appended the records. I kinda doubt it but it might be worth
a try.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
.
Okay, I've found the answer. It is not related to Access

at all, but if anyone else needs to know, here's what you
do. I have Windows NT4.0, so these instructions are for
that OS. Go into My Computer, then Control Panel, then
double-click on the System icon. Once there, click on the
Environment Tab. At the bottom of this window, you will
see Environment Variables/User Variables. The User
Variables box will have columns Variable and Value. Here
it will show you the TEMP environment settings. Examples
are:
TEMP = C:\TEMP
TMP = C:\TEMP

You can click on these settings and then change them. I
changed mine to "D:\TEMP". I then started running my
Access process again and went through explorer to see
where my temp file was being created. And, it had changed
to my D: drive. I hope this helps others!

Thanks!
Sandi