Client has an Access database on the D: drive of a particular server.
MSAccess is installed in the Program Files directory of the C: drive on the
same server. Client needs to compact/repair the database on the D: drive due
to sizing issues. There is enough room on the D: drive to handle the copy of
the database that is created when performing the Compact/Repair. ISSUE: For
whatever reason, the Compact/Repair process is writing some files to the C:
drive (MS Access Installation) during the Compact/Repair process and the C:
drive doesn't have enough capacity to handle these temporary files.
Why are temp files being written to C: when the Original database and the
compact copy are on D:? How can I stop Access from writing the temp files to
C:?
I think Access uses the TEMP folder for the user by default.
It may have something to do with the problems described in MSKB article:
http://support.microsoft.com/?id=295234
especially, if you use A2K0.

Signature
HTH
Van T. Dinh
MVP (Access)
> Client has an Access database on the D: drive of a particular server.
> MSAccess is installed in the Program Files directory of the C: drive on the
[quoted text clipped - 8 lines]
> compact copy are on D:? How can I stop Access from writing the temp files to
> C:?
Alex - 22 Apr 2005 10:24 GMT
start/run cmd
dos prompt,
set temp=d:\
navigate to c:\program files\microsoft office ...
msaccess.exe
do your compact and repair.
should use your d:\ for temp whilst in the dos prompt
Regards
Alex