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