Solved

Folderredirection + Roaming profiles + MS Access

Posted on 2012-03-12
5
434 Views
Last Modified: 2012-03-13
We have an MS Access database that uses the Roaming Profile folder for the front-end and for various temporary files (some of our installations are running on Citrix or RDP and this works really well).  Everything works perfectly, with the exception of PCs that have FolderRedirection enabled.  On those PC we get problems, which appear to be timing & locking issues.

Folder example: C:\Users\Andrew\AppData\Roaming\TS

Is there any way to exclude this folder from FolderRedirection, whilst leaving everything else in tact.  Everything important within this folder is on the server, so it does not need to be synced / backed-up.

Any help would be greatly appreciated.
0
Comment
Question by:Andy Brown
  • 2
  • 2
5 Comments
 
LVL 8

Accepted Solution

by:
Elmar-H earned 300 total points
Comment Utility
0
 
LVL 9

Expert Comment

by:borki
Comment Utility
Why don't you put the Access DB in the Appdata\local\<company> folder. This is where I put my front ends. I figure there is no need to have them roam and being copied back and forth all the time. Some of my front ends are 20+MB and that makes for a big saving on profile space.

Redirected folder is a different concept and does not necessarily have anything to do with the roaming profile. When set using a GPO, I redirect MyDocuments and desktop to  a server location. I still use roaming profiles, but Documents are no longer part of it.
0
 

Author Comment

by:Andy Brown
Comment Utility
That's not a bad idea, but I am not sure that Appdata\local\<company> would work correctly on Cirtix/RDP setups. I may be wrong,
0
 
LVL 9

Assisted Solution

by:borki
borki earned 200 total points
Comment Utility
Works fine on RDS server (2008R2) for two of my clients. Front end runs either on local PC (Win 7) or on RDS server, connecting to backend (full SQL Server) in a different VM.

I use an install/update script for the front end, used every time the program changes, only makes reference to %LOCALAPPDATA%. Biggest hassle is scripting Trusted Location in Access 2007/2010 on initial install, but once set it works OK.

I have no experience with Citrix.
0
 

Author Closing Comment

by:Andy Brown
Comment Utility
Thanks guys - really useful info.

I may post another question about the RDP side of things shortly.
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
Possible fixes for Windows 7 and Windows Server 2008 updating problem. Solutions mentioned are from Microsoft themselves. I started a case with them from our Microsoft Silver Partner option to open a case and get direct support from Microsoft. If s…
This tutorial will walk an individual through the steps necessary to install and configure the Windows Server Backup Utility. Directly connect an external storage device such as a USB drive, or CD\DVD burner: If the device is a USB drive, ensure i…
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…

763 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

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now