1 Reply Latest reply on Dec 13, 2009 12:41 PM by Steve Wright

    Admin access to a Runtime Solution



      Admin access to a Runtime Solution


      In a runtime solution that I've distributed to my customers, I took away Admin access when I created the runtime. Now I've got a customer who has a corrupt date record and I need to get in as admin to delete that record (it is not possible from the front end). I can't do this because I can't log in as Admin to the runtime solution. Does anyone know of a way of getting around this? I know the admin password and enter it when logging into the runtime by holding down the Shift key but the Tools menu option does not get displayed.

        • 1. Re: Admin access to a Runtime Solution
          Steve Wright

          There is no way around this, the remove admin privelages is set in stone at least I hope it is..

          If its not, then we are basically producing open source runtime files...


          Work around :

          Copy the runtime file to your machine and import the data into a copy of your development file

          make the changes and re-import the data back to their system.


          What we do (something to consider for future)

          We also have a maintenance file, which is not distributed to the end user. 
          This is linked to our main distributed files by having them as data sources and is bound to the runtime.
          The maintenance file contains Table Occurences and layouts of all the base tables, with all the fields in place, and a few scripted buttons to allow us to run pre-set functions from the runtime files.

          In case of such problems, we transfer the maintenance file, open it and hey presto.. can manipulate the data in any way required since we have full access to all the tables, fields and menu commands available in a runtime such as importing and exporting, replace all etc etc.



          Edit :

          Thinking about it, you could build the maintenance file now it shouldnt take long to make a crude looking file, linking it to the main db using your dev copy, bind it to a runtime using the exact same details as previously used, then send that one bound runtime file over to your clients machine.. open the solution, then open the maintenance file, this will then allow you to access the data.  When your done, you can simply delete it or leave it in place.