Question Locked

MS Access - Change location of temp files

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

When I run Access it builds the temporary file in the following directory - C:\Documents and Settings\username\Local Settings\temp

Is it possible to change the location to D:, the other partition on my local drive.

I only have 2 gig on C and have 25 gig on D.

Any suggestions?

3 replies

by seanferd

HKEY_CURRENT_USER\Environment

Change the path under this registry key. It will cause all temp files to be stored on the new path.

by rob miners

By rule of thumb Windows likes to have at least 15%-17% free space on all drives for it to function properly. If you are below this limit it is effecting the Operating Systems ability to function properly, try moving some of the files to a central repository {storage area} IE. Burning off DVD's, uninstalling any unused Software and redirecting the My Documents folder.

Create a directory on D: EG: D:\udocs

Select Start, Right Mouse click on My Documents and select Properties.

Select Move and navigate to D:\udocs

Answer Yes to all Boxes

Restart the PC

By doing this you are freeing up the space on C: drive the My Documents was using.

Clean up the Registry and remove temp files.

Registry:

Download and install CCleaner to tidy up your Registry. Backup the Registry as you go along, rescan again and again saving as you go until there are no errors left.

Cleaner: Windows

When you first open Ccleaner you will have an option to Analyze or Run Cleaner, after checking the left Pane and making your choices. Delete all Temp Files. If you scroll down you will see a greyed out box that has Advanced next to it. Left click on it and keep pressing OK to all of the responses. I normally Untick Windows Log Files and Memory Dumps as they may come in handy.

You don't have to install all of the add ons or shortcuts just the one to the Desktop.

http://www.ccleaner.com/download

This discussion is closed to new replies.