From: HarrisJR@bwsc.org   
      
   I recently created a new process with a bunch of PRIV tables and 1 WORK table   
   using Pdox 9 which is loaded on Windows XP SP2 PCs.  The database sits on   
   a Window 2003 R2 SHARE Machine.  During the test phase I gave a Test User   
   FULL CONTROL to my folder to allow the User to 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.   
   The Group has permissions:   
   Read & Execute   
   List Folder   
   Read   
   Write   
      Which translates to ALL permissions except   
      Full Control, Delete, Change Permissions & Take Ownership   
      If ADVANCED button is selected to look at the EFEFECTIVE PERMISSIONS Tab.   
      
   The only thing the new process does that is NOT DONE elsewhere in the App   
   is SORT:   
      cashTbl.attach("CashFlow.DB")   
      sort cashTbl   
      on "Year","ContractNo", "StreetCode",   
                    "RptYear", "BgnDate", "EndDate"   
      to cashTbl   
      endSort   
      cashTbl.UNattach()   
      CashFlow.DB is a WORK table   
   	   
   The above SORT is done 3 times in the ARRIVE event and once in the PUSHBUTTON   
   event.   
   Once you log out of Paradox and go back in you will see 3 TMPSRnnn.db tables.   
      
   How do I fix this and could this be the reason for several GPVs throughout   
   the day while using the App even if you ARE NOT running the new process?   
      
   TIA   
      
   Jeanette   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)