"I also set up accounts for the FM database for each user when they are signed into the hosting computer." - in setting the IWP to be on did you specify which accounts can see it via IWP? And have you set the Groups extended privileges to include access by IWP? Those both have to be explicitly turned on.
Yes, all of the users have full access in the window for IWP. All users can access the database on the web as long as I am the one who is logged into the database on the hosting computer. That hasn't been an issue.
The issue with IWP is that if one of my employees who has full access logs into the database on the hosting computer, the computers which access through IWP cannot even find the web page. It doesn't exist. If they log onto the computer with their log in and then log into the database with my login and password-voila--the internet page is findable and they can access the database through the IWP.
Is the 'other' user a member of the same group as you in the file's Privilege Sets?
i am not totally sure that I understand your question.
In the accounts window which is acessed through Manage>>Security there are three different accounts. When the Privilege Sets button is clicked a new screen opens. In that screen, all three accounts are listed on one line with full access privileges. So, I think that the answer to your question is yes.
Yip, that's right.
I'm running out of ideas. What happens if you move the hosting to any other computer? For the purposes of seeing and opening the file it is shared using TCP/IP protocol and I believe FM manages all the access, so it should work.
I created a user account here with no access to IWP in their extended privileges and launched the Host file with their account. It still shared the IWP and made it available.
Other normal causes of this include things like firewalls, but they would be independent of the FM login.
Actually, to remove some other variables from the problem, you can simply do all of your testing on the same Mac. It will be happy to host the file with FM and also let you open a browser and log on to it with IWP. Saves your feet, anyway, as you check it out.