any accounts that are the same in the GUI file ? Perhaps the GUI file is opening the data file with a certain account?
It is data separation , so when users open the GUI file, yeah it opens that way which i want, but for the purpose of development, sometimes I need to open the file directly. But still want it to be secure. As far as I know, as long as the GUI file is not open or "logged in" in another window, this should always prompt a password.
But without that file open, I can open the data files ("modules" in my solution) directly without login.
From what I can read - provided I have the "Log in As" box unchecked in File Options(of each data "module" file), and accounts and privilege sets in place (beyond the default Admin), which has no passsword, it should require authentication... when opening it outside of the GUI file that is..
Just wondering if there is something else i have to take into account..
Are you leaving FMP running on your client workstation? Even if your data file is not shown, but you opened it through your GUI file which is now closed, FMP will still maintain the connection to your data file. Are you still experiencing the same issue when you close FMP completely (not just closing the last window of your GUI file)?
Hey Eric, yeah I've tried closing FMP completely, even restarting my computer just in case.. it seems a mystery!
What is stranger is it's only about half of the data files I hace hosted that are allowing access.. the pthers are locked as they should be, and I cant see any visible difference in each file's account or security settings....
Are you using a OnLastWindowClose script trigger to specifically close the remote data file or some other script you fire when exiting your solution? If not, and depending upon the amount of time you've set FMS to allow your hosted file to idle, that may keep it open. We purposefully do this on our data separated solutions involving iOS devices so users (of course we also use fmreauthenticate extended privileges too) don't have to re-login or get disconnected. Aside from that, it sounds like you're trying everything I would!
Thanks guys for your responses and help-
Keychain was the key!
I spoke to a colleauge who mentioned keychain as a possibility. I must have at some point selected 'remember password in my keychain' for some of the files, so my computer had saved those passwords...
So, if anyone comes a across a similar issue - could be the keychain....