Access Compact/Repair Issue

[BigDaddy]

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

 

[Van T. Dinh]

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.

 

[Alex]

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