Compact / Repair

[Guest]

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:?

 

[John Nurick]

So many programs need to use temporary files for one purpose or another
that Windows (like other operating systems) provides functions for
handling them and uses a standard location for them. I'd guess that
Access is using this system, in which case the solution is to move the
user's TEMP folder to D:. I think you can do this by changing the TEMP
and TMP environment variables (from the Advanced tab of the System
Properties dialog).