From: HarrisJR@bwsc.org   
      
   CLARIFICATION:   
      
   I found that one of my sort statements on a WORK table did not have an   
   UNattach()   
   after the sort was completed.   
   Once I added the UNattach() statement I am NO LONGER getting the creation   
   of TMPSRnnn.db tables   
      
      
   "Jeanette"  wrote:   
   >   
   >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)