I have developed a database using Access 2010. This is split into a Front End and a Back End.

In the same folder as the Back End I store a number of user modifiable files in either bitmap (.bmp) or MS Word (.doc to retain compatibility with older versions of Word).

Unfortunately, the drive letter where the back end resides will change from location to location and I can't do anything about that as the database is location dependant.

I have set up a function that returns the location of the folder where the docs reside irrespective of the back end drive location, and this works perfectly with OLE linked pictures but not with OLE linked Word documents. User changes show correctly in Word document changes at locations with the original drive assignment but other locations show only the original doc contents even though they have been changed on the local back end location. - even if I delete the Source Item info on the report!!

An example of the code I am using for the Source Item is without the angled brackets of course, where GetBackEndPath() is a global variable storing the location of the documents folder ending with a back slash.

I have tried the above in the reports Source Doc property but Access won't accept this and says it isn't valid for this property.

There are too many reports where various Word docs are linked for me to reprogram them manually for each location.

Hope the above makes sense and help with this is greatly appreciated.

---

Reply from Richard Rost:

How about using a UNC path, like \\SERVER\DocumentFolder and for each location just storing this as a system variable or in a table?