I hope someone can help with this one. I am working on a solution that has multiple database files, all of which require authorization to access each other.
I've just added a new database file to be used on an iPad and the new file is accessing tables from elsewhere. Every time I open the new database, I get the message:
"filename6.fmp12" is not authorized to open the protected file "filename1.fmp12".
Do you want to authorize it?
I have full access privileges for both files so I click Yes and my new file appears in the list of files now authorized. However, the next time I open it, the same thing happens. Sometimes I don't get prompted and get excited, only to find that my remote Table is now "missing" in my relationship graph.
I've tried to manually add the new database file into all the files it will access but to no avail. Can someone shed any light on this.