remove the TO of Untitled from the relationship graph of Untitled2
The uploaded example is just a proof of concept of the behavior in two brand new FileMaker files. I am also experiencing the issue in a real FileMaker solution where I do not have the option of removing TOs from the graph.
1) Add the same user/pass to the first table
2) Delete the user/pass from the second table
The user/pass differ on purpose.
Then your table occurrence reference will attempt to open this file and the difference in account names and passwords will cause it to ask for a password. This is expected behavior for FileMaker files. It's possible that you may be able to cancel the dialog and not actually open it.
I understand how authentication works. The issue is that FileMaker is asking for authentication for a database that was never opened.
May be this will help you to understand better how authentication works...
What if you put into your relationship graph a file for what you haven't the rights to open ?
You seem to wish to open it, but correctly FileMaker does not let you to.
I'm not trying to explain how authentication works, but rather to explain to you why FileMaker is opening this file.
Certain developer actions trigger FileMaker to query all its table occurrences. Apparently, what you are doing with Manage | Custom Menus is one of those actions. Any table occurrences in Manage | Database | Relationships that refers to an external file will then cause FileMaker to open that file in order to access needed info in the file. Since the file in question does not have a Matching account name/password, you get the dialog that asks for them.
It does seem unusual, that you would include a reference to a file in your graph that would not have at least a matching Full access account name and password and if you did, working with Manage | custom menus would not trigger this dialog. What problem is solved for you by not having a matching full access account name and password defined in both files?
FileMaker is opening an externally referenced database (Untitled2) when I close Untitled1.
One way to trigger this behavior is to rearrange the custom menus of Untitled1. Keep in mind that the authentication dialog does not pop up when I go to rearrange custom menus, like it does when I access the calculation window, or look at the relationship graph. The authentication dialog pops up when I close the file.
The reason why accounts differ: I have a utility file that opens with the guest account. The other file is managed by my clients and they control the accounts and passwords in that file.
This may be an obvious thing that you've already ruled out, but do you have a script that runs when the file closes? Have you checked it for anything that might trigger this?
There are no script triggers.
There is a link above to download the proof of concept so you can see the behavior for yourself. Another way to trigger the behavior is to create an empty script in Untitled1.
Definitely bug like behavior and apologies for not spotting the download link sooner.
Just to dot every eye, have any of the menus in custom menu been modified or is the only change made, that of rearranging the order when testing this?
I agree that it's a bug. No worries on the link.
I am using the custom menu set that gets created by default.
Michael Gaslowitz (et al):
PhilModJunk brought this to my attention, and I can replicate the problem.
I have forwarded the information to our Development and Software Quality Assurance (Testing) departments for review and confirmation. As more information becomes available, I will let you know.