Hi Everybody. I've a problem for all of you. I guess it would be hard to explain, but let's try. I've been developing a program for the University (I guess is called "College") where I'm studying. This program uses MDB files. The data that fills this databases are vinculated with DBF (in a server), which are modified by a main program (very old) written in Clipper. As I couldn't index this MDB-DBF database the program is pretty slow (all the search ar sequentially, obviously). The Clipper program indexes the DBFs, and actually uses them but are not the same type as the Access allow (they're NTX and Access allow NDX). I know that in Clipper you can specify another driver to use the other type of index, but that would mean to change the Clipper program's source. Besides, I tried to make some test about it. I make a MDB, vinculated with a DBF and index it by an NDX, and everything seemed to be glad. But, when I tried to open the index form VB I couldn't. I was trying the classical:

Table.index = "NDXIndex"

But seemed not to be nice for VB because he refused to execute that command.


I don't know if I was clear or not... but let's see if anybody understood me