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!