Conversion from DBase III system to Access 2002

[Chad Waldo]

I have an old program that I am using for tracking orders,
its totally dos based. I can link an access database to
these .dbf's and I can read/write as well. But I can not
make a link between the linked databases inside access
(relationship). I can do this in Access 97, but 2002 will
not let me. I installed the latest Jet 4.0 engine service
pack, but that did not fix the problem. Has anyone ever
had this problem?

 

[Joe Fallon]

1. I would stick with A97 if it is working for you. MS totally changed the
way newer versions work with dBase.

2. Re-write the whole thing in Access.
Many years ago I re-wrote a dozen or so dBase III programs in Access.
The only thing I could salvage was the raw data.
I imported each file into an Access table.
Then I built NEW tables using relationships, etc.
Then I ran queries to load the new tables with the raw data. And then I
deleted the raw tables and was left with a brand new Access mdb that could
be used to build an app.
(I vaguely recall that it was easier to leave the new tables empty until the
last possible minute so in case you made any changes to datatypes,
relationships, indexes, etc. they would work.)