[AccessD] Importing (or linking to) Paradox files

Steven W. Erbach serbach at new.rr.com
Fri Feb 27 21:09:06 CST 2004


John,

>> My question is are there versions of paradox files that Access can
understand these but not those?  Are there various drivers that need to be
downloaded or something? <<

Since Borland stopped development of the Borland Database Engine (BDE) some time ago I doubt that there would be new table drivers. The last version was 5.1, I believe, in 1999!

Paradox table formats have changed over the years, but I don't think there were any changes after version 7.

Are there supposed to be any Memo fields in the Paradox tables? Paradox is a file-based database and Memo fields are stored in an .MB file separate from the .DB file. However, if your customer only sent you the .DB files that may be the problem. Paradox spawns off a whole mess of associated files for each table depending on how many indexes you create: .DB, .MB, .PX (primary key), and "secondary" indexes take up pairs of files: .XG0 and .YG0 and a whole slew of .XGx and .YGx files, one pair for each index.

Maybe your client didn't send you all the files that go with each table's "family". If you'd like I could take a stab at a couple of your problem .DB files. I have Paradox 9, 8, and 7 as well as Access 97, 2000, and XP.

Regards,

Steve Erbach
Scientific Marketing
Neenah, WI
920-969-0504

"Without men, civilization would last until the oil needed changing." - Fred Reed




More information about the AccessD mailing list