home bbs files messages ]

Forums before death by AOL, social media and spammers... "We can't have nice things"

   comp.databases.paradox      To crash or not to crash, asks Borland      9,834 messages   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]

   Message 9,823 of 9,834   
   me@alandmoore.com to All   
   Tools to help analyze/cleanup a paradox    
   12 Jul 17 11:32:01   
   
   Where I work, we have "The T:\ Drive".  This shared directory contains the sum   
   total of the Paradox data files generated by about 50-70 concurrent employees   
   in half a dozen departments over the course of more than 20 years.   
      
   And it's a mess.  It's about 1700 files.  A good chunk of it was created by   
   employees long since retired.   
      
   My task is to go through it, clean it up, and identify distinct "applications"   
   within this directory.   
      
   So far I've been using Paradox itself, filesystem tools, binary dumps, and   
   other rudimentary tools to try to identify what's being used and what isn't.    
   But I'm wondering if there are third party tools to help out here.   
      
   Some specific questions:   
      
   - I know generally that index files share the same base name as the table they   
   belong too.  So "foo.YG1" belongs to "foo.db".  But is this always the case?    
   Is it possible, through renaming or other processes, that "baz.XG0" belongs to   
   "foo.db", and --    
   if so -- how do I identify that connection?  Or can I safely assume that   
   "baz.XG0" belongs to a deleted table?   
      
   - Most of our reports pull data from a generic "ANSWERS.DB" table, which might   
   be generated by any of a hundred QBEs (IOW, most of our QBEs output to   
   "ANSWERS.DB").  I can't see a way of identifying which QBE belongs to which   
   report other than    
   painstakingly comparing the output fields to the expected input fields and   
   making an educated guess.  Am I missing a tool that would help here?   
      
   - Is there any way to see when a QBE or table was last used (e.g. run/read, as   
   opposed to modified)?   
      
   Thanks for any help you can offer!   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]


(c) 1994,  bbs@darkrealms.ca