Andrew,

Please do the following:

Create a database called DeleteMe. Add Table1 (Field1 C(10), Field2 I). Put a Primary or Candidate index on each field. Don't add any records.

Go into MS Access and link to DeleteMe. (You'll need to make a datasource or whatever.)
Start adding records:
Add "abcde", 0
Add "abcde", 0 again.

Decide by what happens whether indexes are updated properly when VFP databases are used through ODBC. (If you're still not sure, post back and I'll tell you what happened when I did it.)

Lesson, don't assume, perform a simple test. You'll learn a few things along the way! ;-)


>Well, does the VFP ODBC driver update indexes correctly? If so, then I can index. I had assumed that it did not. I have already discovered that, despite the MDAC documentation, the ODBC driver is not thread-safe.