Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Conversion / April 2005

Tip: Looking for answers? Try searching our database.

Access Compact/Repair Issue

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
BigDaddy - 21 Apr 2005 15:28 GMT
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 - 22 Apr 2005 09:27 GMT
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
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.