I'm accessing a database via a RDP connection using TS 2000. All is working
fine except for one problem with mail merges with Microsoft Word. When a
user does a mail merge the data source is exported to this directory:

C:\Program Files\FileMaker\FileMaker Pro 6\datasource.mer

This is fine for LAN users as they each have their own computer, and the
only limitation is 2 people can't have the same letter open at the same
time.

When accessing via TS however it seems like everyone is sharing the
C:\Program Files\FileMaker\FileMaker Pro 6\ directory so in effect only one
person can have a letter open at any one time as all users are sharing the
same data source. I'm trying to come up with a way around this and was
wondering if anyone had come across this before? What I need is a directory
that is unique to each TS user where I can store the datasource but the path
to that is the same for all users (as each MS Word letter has been set to
locate the datasource in the C:\Program Files\FileMaker\FileMaker Pro
6\datasource.mer directory which works as it is the same path for all
users).

Many thanks - Andrew