I got a message when I tried to create a Remote View using ODBC. In the Microsoft Visual FoxPro Window it reads as follows:

"Connectivity error:(Microsoft)(ODBC Visual FoxPro Driver) Primary key property is invalid; please validate database.

Followed by OK or Help.

I have 4 .DBFs that I want to set up in my Remote View. I have 1 out of 4 that works and adds a table to my remote view. The only difference I can see between the 4 tables is that the one that works had an index identified as "Candidate" the others have indexes as "Primary". When I change their indexes to "Candidate" I still get the error and the other 3 tables never get added to my Remote View.

What's happening here? I Validated the DB, but no help. Thanks for helping.