Bummer - will have to work something else out as i think the 1gb data allowance (free) in dropbox may run out pretty quickly!
Btw, Iwill eventually put the database on my new server but I am unsure how i would write the path to it in a script from a client computer...
Assuming my db file is in a folder called 'database' which will be located in the documents folder on the server, how would i write this up?
I depends on what your are trying to do with the "file path". Why save files on the client computers? Then they have to manage them. Most of the external file stuff I do, can be made relative to the Server DB.
Try FMP help ... with this search .... files and folders
Note the both Windows and MacOS have a prenamed folder called "Documents", which is a common location on all platforms on a "Client" computer.
Sorry - I meant that when the uses are usng the database, I want them to be able to create a new folder on the server - but I need to able to tell the FM program where the folder is and what machine - in this case the server. I shall look up files and folders as you suggest anyway.
One last thing - Although we are a small company (6 computers/users) is it worth getting fm server? What would be the advantages and is it easy to set up?
If you make all of your folders, relative to the Server or HOST db, then it will always "follow the leader" so to speak.
There is a good guide on HOSTing versus Server in the Knowlege Base. I have done both, and once set up, perfomance is same. The Server has many advantages in maintenance.
PS: Creating folders from several Client computer will result in the need to do a "clean up" eventually. So putting them in a Folder to isolate them may be helpful...