Paradox Community

Items in comp.databases.paradox

Subject:Re: Tools to help analyze/cleanup a paradox data directory?
Date:Tue, 8 Aug 2017 13:24:02 -0400
From:"Steven Green" <>
don't know if my current ISP is communicating with c.d.p. in real time, 

the indexes always go to the table of the same name

to see which query is used by which report, you'd have to see the code.. 
it'll call some qbe file, then maybe do more manipulation of the table, then 
call an rsl file

the only way to see if files were recently used, is if the app itself tracks 
that (code written to do it, there is no default tool), or if a network tool 
has been doing that.. if everything is simply "answer", it ain't easy :-)

without knowing how the app was written, and how the coder typically did 
stuff, there are no standard rules


Steven Green
Myrtle Beach, South Carolina, USA

Collectibles and Memorabilia
Vintage Lego Sets and Parts
- and Paradox support, too

wrote in message

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! 

This email has been checked for viruses by Avast antivirus software.

Copyright © 2004