>We have an application which contains modules developed in VFP and VB.
>We have recently discovered that if a VFP module and a VB module attempt to update the same table and the same time that the index is not updated. The records created by the VB module are in the table but cannot be SELECTed.
>
>Any ideas?
How are you accessing the VFP table from within VB (Jet, ODBC, ADO, ?)? It sounds like you're writing records into the table without having the proper index open. If you're using .IDX files, or a non-structural .CDX file, or using an older driver that does not support structural .CDX files (like the generic xBASE ODBC driver) this is the most likely scenario.