<div>
<div class="content wysiwyg-content">
We are looking to move our access databases onto a terminal server in our virtual datacentre. &nbsp;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. &nbsp;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.<br />
<br />
Is there a way to get Access to create these temp files somewhere else? &nbsp;Preferably on the C drive.<br />
<br />
Unfortunatly we cannot change the My Documents setting as this is used to move files onto the TS.<br />
<br />
Thanks in advance all for your help!<br />
<br />
<br />
Matt
</div>
</div>


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

MS Access Temp File Location on Terminal Server

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

Windows Server 2003 was based on Windows XP and was released in four editions: Web, Standard, Enterprise and Datacenter. It also had derivative versions for clusters, storage and Microsoft’s Small Business Server. Important upgrades included integrating Internet Information Services (IIS), improvements to Active Directory (AD) and Group Policy (GP), and the migration to Automated System Recovery (ASR).