I wrote a custom database system for a customer almost 13 years ago using compiled basic (Quickbasic). The system still works fine and occasionally I do modifications to it, however I am looking at re-writing it all in QB. Most of the data files are small enough that I used simple sequential reads, but the master inventory file (92,000 records) uses a binary search routine. My question is this...

Should I continue to use random access files (there are lots of superceded parts that point to other parts using their record number), or should I import all the data into access format, or dbase format, or what??

Sorry the question is so vague.. but before I start putting in lots of hours I would like to hear some input from people who know what they are doing.

BTW I have only dabbled in QB... but with basic (sort of like latin, a dead language) I was very proficient.

Thanks in advance for your input!