Solved

MS Access Temp File Location on Terminal Server

Posted on 2011-03-24
2
378 Views
Last Modified: 2012-05-11
We are looking to move our access databases onto a terminal server in our virtual datacentre.  It was all working well until we experienced performance issues which relates to temp files, which Access seems to be creating in the My Documents folder.  Our My Document folders are housed on a file server in our office locations meaning that the temp files are getting transfered over the WAN.

Is there a way to get Access to create these temp files somewhere else?  Preferably on the C drive.

Unfortunatly we cannot change the My Documents setting as this is used to move files onto the TS.

Thanks in advance all for your help!


Matt
0
Comment
Question by:matthewwilliams
2 Comments
 
LVL 7

Assisted Solution

by:RemRemRem
RemRemRem earned 200 total points
ID: 35208781
To my knowledge, Access unto itself doesn't create "temp" files except for the <dbname>.ldb file that gets instantiated upon opening. That gets created in the root folder from which the DB is being opened.

This sounds like one of a couple things:

Either you're actually having users open a local front end, even though the data is in the virtual center (not likely, given your description), or the specific database you have is doing a process it's programmed to do which happens to have temp files. For example, it might be writing report files out temporarily in order to convert them to PDFs. In that case, you'll need to go looking in a couple places. When I do such file handling, I tend to create a table of default paths, which can be updated as needed by the owners. It may be a hidden table, and the format of the path name is vital (if the current one has a "\" as its last character, make sure your new path does, too, and so on). The other way to do it is to hard code it into code. This means you'd want to open the DB's module(s) and do a search for that "my documents" path and modify it in the code as needed.

-Rachel
0
 
LVL 57

Accepted Solution

by:
Jim Dettman (Microsoft MVP/ EE MVE) earned 300 total points
ID: 35208786
Matt,

 I believe Access/JET uses the TMP and TEMP environment variables to determine where to create temp files.

  If you don't have them defined, define them, or if you do, make sure they point to the TS drive's.

JimD.
0

Featured Post

Salesforce Made Easy to Use

On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Restoring deleted objects in Active Directory has been a standard feature in Active Directory for many years, yet some admins may not know what is available.
You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …

733 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question