I need to read on old paradox 3.2 db file and then create a new
paradox 3.2 file. Is there anyway to do this from windows? What
sowftware do I need?
Thanks,
Dave

actually, there's no such thing as 3.2.. there are level 3 tables, and
paradox dos versions 3 (and 3.01a) and 3.5 (and 3.51).. hopefully, you're
talking about level 3 tables..

first, a really important question.. what program will be using the result
of this?.. there are many good reasons to NOT use level 3 tables, and even
ore reasons to NOT use the version 3.x program..


--
Steven Green - Myrtle Beach, South Carolina 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

"Spriggly" <Spriggs.D (AT) gmail (DOT) com> wrote

I am working on a project to remediate SSN from a very old door
security system that uses an id badge incoded with SSN. We are getting
new ID badges with a new non SSN number. I am not up grading the old
software itself, I just want to change data in the database. The door
lock system uses paradox 3.2 as the database. I need to read the
paradox .DB files and update the data to the new number that will be
on the card. Better yet, I would like to create a new .db file that
has all the new data but the same structure as the old files so that I
can drop it into the door lock system and be up an running.

Thanks for any tips...
Dave

OK.. sounds like you're dealing with level 3 tables.. just about anything
that works paradox tables will work the level three tables.. paradox,
access, delphi, dbase, etc.. just make sure you get the table level right,
or the old app won't read the new or updated files..

--
Steven Green - Myrtle Beach, South Carolina 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
"Spriggly" <Spriggs.D (AT) gmail (DOT) com> wrote

Ok... How can I tell for sure the level of the existing files?

Thanks,

there's a free tool on my web site, Tdr.zip, that can tell you the table
level of paradox dos tables.. or paradox, the software program, can tell you
the level of the tables.. I sell paradox on my web site, too..

--
Steven Green - Myrtle Beach, South Carolina 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

"Spriggly" <Spriggs.D (AT) gmail (DOT) com> wrote

I used your TDR and looked at the original file and got this:

FILE NAME : C:\STUFF\TDR\DB121807\ITIACC32\DATABASE\MISCFLD.DB
12/01/2007 10:49:26
File type = Keyed DB
Number of Fields = 19
Key Fields = 1
Format = Paradox 4.0
Sort Order = ascii
Code Page = 437
Record Length = 480 (1E0 hex)
Header End = 521 (209 hex)
Data Start = 2048 (800 hex)
Header Version = 2 (2 hex)
Index Version = 243 (F3 hex)
Family Version = 141 (8D hex)
Block Size = 2048 (800 hex)
No of records = 2186
Used blocks = 580
Records / blk = 4
Total blocks = 580
First block = 1 (offset 800 hex)
Last block = 556 (offset 6000 hex)
First Empty block = 0
Password = NO
Write Protect = NO
Pack Ratio = 94%

Next I opened the file with access, did nothing to it, then saved it
as a paradox 4 file. I then looked at this new file with TDR and got
this:

FILE NAME : C:\STUFF\TDR\DB121807\ITIACC32\MISCFLD.DB 12/18/2007
15:01:58
File type = Unkeyed DB
Number of Fields = 19
Key Fields = 0
Format = Paradox 4.0
Sort Order = ascii
Code Page = 0
Record Length = 480 (1E0 hex)
Header End = 521 (209 hex)
Data Start = 2048 (800 hex)
Header Version = 1 (1 hex)
Index Version = 212 (D4 hex)
Family Version = 211 (D3 hex)
Block Size = 2048 (800 hex)
No of records = 2186
Used blocks = 547
Records / blk = 4
Total blocks = 547
First block = 1 (offset 800 hex)
Last block = 547 (offset 1800 hex)
First Empty block = 0
Password = NO
Write Protect = NO
Pack Ratio = 100%

I noticed some diffrences, are they ok or will this be a problem if I
try to drop the new file into the old software/database.

Thanks,
Dave

Also I nitoced that access does not create a .px file. Is that a
problem?

Thanks,
Dave

You stripped the primary index (key) out when you saved it. (that's what
the px file is) I would certainly expect that to create a substantial
problem.

Denn Santoro
President
Resource Development Associates
http://www.RDAWorldWide.Com
Offices in the United States and Germany
Providing solutions to health care, business, governments and
non-profits since 1982

Spriggly wrote:

Dave.. same answer as Denn's.. yes, removing the px file is big.. it's the
primary index.. and, as you see, it's a level 4 table, not a level 3 table..
is this a one-shot deal, or a regular thing?

--
Steven Green - Myrtle Beach, South Carolina 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

"Dennis Santoro" <RDAPres (AT) NoRDASpamWorldWide (DOT) com> wrote