In order to have a more complete picture:
How are you hosting the database? With Filemaker Pro or Filemaker Server?
Are they using "remote host" to connect to a database that is already open on another machine or ...?
What operating systems are involved?
Using FMP Pro to host. User are mapped to the Network Share that has the database located on it. We are at a major University where there are several networks. Part of the users are on one network and the others on another. Utilizing static IP addresses, the users connect to the network where the database is located. The other users are on the same network where the databases are located.
No matter which side connects first, if users from one location connect prior to users at the other, the users at the other location are locked out. However, users at the same location can connect to the same database (as a Multiuser database) with no problem.... just seems odd.
Didn't know if coming across networks like this would case weird file handles to enter in to the equations... Also didn't know if the version was causing the problem.
Thanks for taking the time to reply to my post.
"User are mapped to the Network Share that has the database located on it."
This part concerns me a bit.
Which scenario matches how you host your database?
Method 1: (Strongly Recommended by Filemaker Inc.)
You always open the database first on the computer where the files reside. Then all your users launch filemaker, select Open Remote, and select the host computer and file from the listed computer(s) and file(s) to open it.
Method 2: (Not recommended, dangerous to your data)
Each user navigates to the shared directory and connects to the database by opening the database file.
If you aren't using Method 1, try it and see if you stil have a problem.
We are using Method 2; so that explains what the problems might be.
I will move the database from the Shared Directory and try accessing it remotely. Is there anything about the PC configuration/permissions I need to be aware of or do in order for others to access the database on a particular PC (Host)?
Thanks again for your help.
Phil is absolutely correct. You should eing using Open Remote. Port 5003 must be open.
Before moving the database, I connected to the database (using the "Open" command from the Network share) seeing how I was the first in. Then I went to another users desktop and did the "Open Remote" and it showed me the user currently using the database. When I selected it and pressed open, it open as I expected.
Does this mean that it still connected to the database on the Network Share?
This is the way you are supposed to host filemaker databases over the network.
If you now go the host computer and try to quit filemaker, you'll get a message telling you that there's another guest using the database and an offer to send them a message so that you can ask them to quit if you want.
THANKS !!!! YOU GUYS WERE A GREAT HELP... HAVE A WONDERFUL DAY!