Solved

MS Access Temp File Location on Terminal Server

Posted on 2011-03-24
2
380 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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 58

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

Get HTML5 Certified

Want to be a web developer? You'll need to know HTML. Prepare for HTML5 certification by enrolling in July's Course of the Month! It's free for Premium Members, Team Accounts, and Qualified Experts.

Question has a verified solution.

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

This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…

615 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