[AccessD] Importing (or linking to) Paradox files

That may very well be it.  I asked specifically only for the .db files
because he sent me a hundred files for just 3 tables.

John W. Colby
www.ColbyConsulting.com

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Steven W.
Erbach
Sent: Friday, February 27, 2004 10:09 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Importing (or linking to) Paradox files


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

--
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com