| Author |
Access Compact/Repair Issue
|
|
| BigDaddy 2005-04-21, 9:24 am |
| 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 2005-04-22, 3:24 am |
| 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.
--
HTH
Van T. Dinh
MVP (Access)
"BigDaddy" < BigDaddy@discussions
.microsoft.com> wrote in message
news:BC3CE2CA-64D1-4102-A9A7- 762CF995C737@microso
ft.com...
> 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:?
| |
|
| 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
|
|
|
|