Jump to content
Sign in to follow this  

Related databases shared by a host computer?

Recommended Posts

A quick question. I have a computer set up as a host to share a database over our local office network. The database is relational with 2 other database files. Do I need to have all 3 files open on the host computer to have them be shared? Or do I open the main database only, and since it is related to the 2 other files will they all automatically be shared over the network?


Share this post

Link to post
Share on other sites

If the main file is open on your machine you are the host, and other users will tap in as a guest if they open that same file.

If however, while they're working as a guest on the primary file, and any of the other related (but not open yet) files are needed (portals, related fields in layout etc. etc.), FMP will allow them to open the necessary files, but with the (first) user (to open it) as that file's 'host' -- even when the file is not on their machine. It will work, but not very well, and it will drag on speed, reliability, stability, etc. etc.

It's much better if you are using FMP (but not FM Server) on your machine, and acting as host for the office, to set up all your files to be open and set to multi-user on your host machine all the time. That way none of the guests will become remote-hosts. They will always be guests (because the files are already open and being hosted by your machine).

A quick open script on the primary file that opens all the related files as well should do the trick. That, and don't let other users access your machine directly. Ensure they only open FM files via the Host option in the Open Window. Or better yet, place a small dummy FMP file on each computer (with an alias or shortcut on the desktop) that (in its open script) finds the primary file on your machine and autoopens it, and then promptly closes itself (the small dummy FMP file) again.


Share this post

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

  • Create New...

Important Information

By using this site, you agree to our Terms of Use.