I am trying to automate the import of data that is given to me periodically in dBase IV format. Actually it is produced by Codebase. The problem is that I am only receiving the .DBF file and I am not being given the associated .MDX file (the dBase way of doing .CDX files).

When opening a Fox DBF that is missing a CDX, I can just set SAFETY OFF and go ahead, however, I believe Fox is trying to convert the non-existant MDX into a CDX and therefore I get error 1707 (non existant CDX) that I can't get around in code!

If i do this interactively, I get the usual dialog box to ignore/cancel where I can severe any MDX/CDX requirement, but what can I do in code?


Thanx