Folderredirection / Synchronisation

One of my clients has recently had a new server installed (running MS Server 2008) and we are now seeing the occasional issue.  

One of the functions copies a selected Access 2003 MDB file to the local drive, so it can run some reports a little quicker (local as opposed to across the network).  On this one site, it intermittently appears to fail when copying the file to the selected folder.  I do have a function that waits until it can see the file exists before running the link/queries - but this may flawed (something I am looking into).

That said, I am wondering if the Folderredirection / Synchronisation may be having an affect and need to know if it can be easly switched off on a PC/login profile - so that I can test further.

All of the PCs are running Vista or Win7 and are tightly locked down, whilst the MDB file being copied should end up in the following directory:

XXXXX = The user/login name

I guess it could also be a permissions issue (not sure at this time), so any other suggestions/help would be greatly appreciated.
Andy BrownDeveloperAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Ayman BakrSenior ConsultantCommented:
The parch you are providing is the path you are copying from or to?
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Where is it being copied from?

How are you copying it? Are you using FileCopy, or some other method?

Folder Redirection could possibly cause this, but it would be a constant issue it would seem.
Andy BrownDeveloperAuthor Commented:
Sorry guys

This is the path we are copying to:
The source file is being copied from a drive on the server;  X:\TS Data\TSBE1.mdb
I am using the FileCopy command within VBA
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

Rey Obrero (Capricorn1)Commented:

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Have you tried using the UNC path instead of a mapped path:

Filecopy "\\Server1\MyFolder\MyDatabase.mdb", "C:\Folder2\MyDatabase.mdb"

Andy BrownDeveloperAuthor Commented:
Thanks capricorn1 - I'll take a look
Thanks LSM - I've been thinking about doing this for a while, but it's probably a couple of days work to configure, test & deploy - so it's on the list.  It maybe another question, but does using the UNC path as opposed to X:\..... make any difference to reliability / performance (happy to post another question for this)?
Ayman BakrSenior ConsultantCommented:
Why don't you try ruling out permission issues by copying to a local destination rather than a profile destination?
Andy BrownDeveloperAuthor Commented:
Thanks for your help on this - sorry for the delay in comming back to you.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.