From: HarrisJR@bwsc.org   
      
   I recently created a new process using Pdox 9 – Windows XP SP2   
   with a bunch of PRIV tables and 1 WORK table.   
   During the test I gave a Test User FULL CONTROL to my folder   
   so that User could enter data and troubleshoot the new process.   
      
   Now that I have moved the process to Production   
   a TMPSRnnn.db is created when a User (and not me) runs the process.   
   The Users that are allowed to use the App in Production are in a Group.   
   I now see that the Group has permissions:   
   Read & Execute   
   List Folder   
   Read   
   Write   
      
   While watching Shark last night I had ‘a moment of brilliance’ and thought   
   that maybe I should add MODIFY Permission to the Production table so that   
   the Users can sort the table and eliminate the creation of the TMPSRnnn.db   
   table !   
   Bad Idea.  :(   
   Not only was the TMPSRnnn.db created but the Production table was DELETED!   
      
   There are no other processes in Production where the User sorts a Production   
   Table - keys/index will not work for the new process...  well they probably   
   will if I worked at it – but for now I need to find out about the TMPSRnnn.db   
   table that’s created and move on and maybe get back to this process sometime   
   in the future to implement keys/index …   
      
   1. My in-house Admin Staff has never heard of TMPSRnnn.db tables   
   2. Is my thinking correct about WHY TMPSRnnn.db table is created?   
   3. Did the addition of the MODIFY Permission cause the deletion of the   
   production   
   table?   
   4. If I give Full Control to this one table what can the Users do that they   
   are unable to do with the other tables in Production?   
      
   TIA   
      
   Jeanette   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)