From: HarrisJR@bwsc.org   
      
   These TMPSRnnn.db tables are not created by me and saved and used in the PRIV   
   directory.  They are being created by Users that DO NOT have FULL CONTROL   
   permisions in the WORK directory in the background.   
   I thought I had made that clear, sorry...   
      
      
   "Steven Green"  wrote:   
   >> 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)