1 Reply Latest reply on Sep 17, 2013 12:40 PM by philmodjunk

    Security and Password set up

    FilmUser

      Title

      Security and Password set up

      Post

           I am helping a company convert an old FMP5 system of about 25 data bases into one file, via FMP11, then to 12.

           FMP 11 will not import the FMP5 files into the main new file, so I am converting each old FMP5 file into an FMP11 file first, then will be creating new tables by importing these FMP11 files as tables.

           The account / password system is changing, there will be 10 or so accounts, each with its own password, and every table will have the same set of accounts, each with its own same password. At the moment, I have removed all security from the old FM5 files.

           First question - is there a way to add the security accounts more easily than entering each name and password in every table one at a time? I don't see anything indicating that FM Advanced can do this. (I don't have Advanced, but might push for it if it could).

           Also, does it matter the sequence of conversion to 11, account set up, import into the new 11 solution, and setting up relationships? Some simple tests show that relationships convert well, even if the related file is not yet converted, but I wonder if there are any tips anyone can offer as to sequence or strategy.

           Thanks in advance for your help.

        • 1. Re: Security and Password set up
          philmodjunk

               Accounts and passwords are specified for the FILE not the table. Thus, if you are importing all your data into a single file, you need only set up accounts and passwords a single time on this single unified file. You can set up scripts that create and modify accounts in multiple files and this is often done, but that does not appear to be what you are creating here.

               If you are importing data from individual file into a single unified file, you are only able to import the table, the relationships will have to be manually recreated in the new file anyway.

               The existing relationships as recreated in the converted copies of your original single table files will only be of use to you if you don't merge all the individual files into a single unified file.