Thanks Paul, that's the direction it seems that I'm going to take but interesting found thru googling that Sybase ADVANTAGE has a odbc driver that supports xbase and idx, interesting!


>>Thanks for the response Thomas, the files actually have a CDX as well but can't get rid of the IDX for now, it's a system gone bad basically, over the years they never updated, they just added stuff on top. So basically we also need to have the IDX open, one developer already researched and couldn't make it work and started creating the workaround and it was handed to me, unfortunately the deadline is almost up so don't have the usual period for trial and error/testing, so I will continue working on his workaround unless I know for sure that someone has been able to read and update foxpro data that contains an "IDX".
>>
>>
>
>In this case you're probably better off with the COM component solution. If this is a possible multithreaded situation, I'm almost always happier just wrapping the calls in a lock. It's easy and avoids odd issues.