From: greens@diamondsg.com   
      
   > the production area will be filled up with unneeded data SINCE they are   
   > not being dropped   
      
   temp tables only appear in the PRIV, and can be safely deleted externally,   
   on the way out, or before re-loading.. if they're appearing in what you   
   think is the "working" directory, you've got a problem..   
      
      
   > BUT I'm STILL interested in replies to 1-4 below   
      
   >> 1. My in-house Admin Staff has never heard of TMPSRnnn.db tables   
      
   you hadn't, either, right? (g)   
      
      
   >> 2. Is my thinking correct about WHY TMPSRnnn.db table is created?   
      
   if your theory was that it was the User account, no..   
      
      
   >> 3. Did the addition of the MODIFY Permission cause the deletion of the   
   >> production table?   
      
   don't know anything about your app, but again, no..   
      
      
   >> 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?   
      
   you MUST give full control to every folder that uses Paradox.. if for no   
   other reason, that's what is needed for the lock files to work properly..   
      
      
   --   
   Steven Green - Waldorf Maryland USA   
      
   Diamond Software Group   
   http://www.diamondsg.com/main.htm   
   Paradox Support & Sales   
      
   Diamond Sports Gems   
   http://www.diamondsg.com/gemsmain.htm   
   Sports Memorabilia and Trading Cards   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)