Hello all,

I'm running a multiuser FM database on Windows XP & 2K with many remote users. The remote users access the database using Terminal Services. We have the Terminal Server machine locked down pretty tight for obvious reasons so users can't just create files anywhere they want.

I have created a script that does a simple export of the found set to a specific folder "c:fmprofile.dbf" and then opens the file that was just created with Excel. This works fine when using a local copy of FM but when running on the Terminal Server that folder is not open to everyone with read and write access. Now I could change permissions so that it was open to everyone but then there is the possibility of users writing over each other's files.

I'm thinking a better way would be to direct the output to:

C:Documents and SettingsUsernameMy Documentsfilename.dbf

The normal syntax for doing something like this would be:

C:Documents and Settings%Username%My Documentsfilename.dbf

%Username% would get the current user's name but when I try that in FileMaker it changes it to something like this:

C:Documents and Settings%25Username%25My Documentsfilename.dbf

Since the file path and name cannot be a FM cauculation I can't go that route.

Any ideas?

FM will not recognize environment variables on its own, unfortunately. Your best bet will probably be to export the file to a known accessible directory (say, C:PFFMFMP7) and then use a Send Event step to move the file to the My Docs directory:

Send Event ( "cmd /c ""cd %userprofile%my documents;move c:program filesfilemakerfilemaker pro 7filename.dbf filename.dbf"" " )

J

Did you try using the "All Users" folder?

That is something that they all have in common. You could create a folder there for your file or just use all users/desktop and it would appear on the users desktop.

cluttering a desktop is never a good thing but it is an option.

c:documents and settingsall usersdesktop

Edited July 25, 200520 yr by Guest