6 Replies Latest reply on Mar 13, 2014 2:27 PM by CaseyRodriguez

    FM 11 Permissions Issue Between Tables

    CaseyRodriguez

      Title

      FM 11 Permissions Issue Between Tables

      Post

           Hello,

           Recently I was assisting an employee who was having a problem when working between tables. When accessing the database she would use her username that was allowed "All Access" but after signing in for the first table the following tables would not accept her username and password. Our standard user with "read only" access would work for the following tables.

           This would prevent her from being able to edit/change information and she would then have to forward this information to another colleague who also has all access.

           My assumption is that she has permissions with the first part of the table but other tables in the database are not giving her access. 

           I looked over her permissions and also the table relationships. What can I do to ensure that her username and password can be used on all of the tables she is trying to access?

           Regards,

           Casey Rodriguez

           RSD Technology Support Specialist 

        • 1. Re: FM 11 Permissions Issue Between Tables
          philmodjunk

               "Tables" or "Files"? They aren't the same thing. One logs on with an Account Name and password (Not user name--that's different) and they are set on each file, not each table. The settings in  Manage | Security are specific to each file, so it is possible to use an account name and password to open file 1 with full access, but if the privilege set for that account name and password in file 2 is not set for full access, accessing tables in file 2 will not be full access.

          • 2. Re: FM 11 Permissions Issue Between Tables
            CaseyRodriguez

                 Hi Phil,

                 I was wondering if my terminology was correct in regards to the Table and File. I understand what you're saying with the AccountName associated with each file and I'm assuming that is the problem. Do files sometimes have tables that access information from other files and this would prevent someone from editing that table because they lack the permissions? 

                 Example:

                 I open a file that I have Full Access with my AccountName

                 This file uses tables from other files that do not contain my AccountName and therefor there is an error when I try to use it. 

                 Regards,


                 Casey Rodriguez

                 RSD Technology Support Specialist
                  

            • 3. Re: FM 11 Permissions Issue Between Tables
              philmodjunk

                   Yes, A FileMaker file can have external data source references that reference data in other files. Once upon a time, fileMaker files were limited to one table to a file and such file references were the only option to relate different tables. While we can now define multiple tables in the same file, FileMaker still retains the ability to reference data in other files.

                   In a given file, you can use Manage | External Data Sources to see a list of all external file references for the file that you currently have open.

                   If you open Manage | Database | Relationships and look at the table occurrence box names, those that are in italics will be referencing data from an external source.

              • 4. Re: FM 11 Permissions Issue Between Tables
                CaseyRodriguez

                     Thanks for your help Phil.

                     Upon further investigation I found that they are actually using FileMaker Pro v11 Server.

                     I've also found that the files that are attached to certain tables were converted over at some point and have the "manage" section blurred out. I'm not sure exactly how I can change the permissions on those files but it looks like that is the reason why they are having problems. 

                     If you have any other advice I'd appreciate it.

                     Regards,

                     Casey Rodriguez
                     RSD Technology Support Specialist 

                • 5. Re: FM 11 Permissions Issue Between Tables
                  philmodjunk

                       The "manage" menu should be accessible if you have the file open with a full access password. The fact that the files are hosted on FileMaker server 11 should not affect this. A custom menu, however, can be used to disable or remove a menu for a particular layout. Do you have access to FileMaker Advanced?

                       You may also be able to access these other files just by pulling down the windows menu and looking to see what is currently open.

                  • 6. Re: FM 11 Permissions Issue Between Tables
                    CaseyRodriguez

                         I'll let you know what I'm able to do once I head back over to that office. Unfortunately I don't have access to Advanced.