Visual FoxPro General
You may check to see if you have same problem like:
http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1167816&SiteID=1
also you may update ODBC Driver from:
>>The bug is: driver doesn't support autoincrement fields
As Cetin says, this is not a bug!
The ODBC Driver is only valid for tables that use features available in Visual FoxPro Version 6.0. If a table (or DBC) uses features introduced later it is not readable by the ODBC driver.
The VFP ODBC driver is not being updated because the preferred methodology for accessing data in a Microsoft environment is to use OLEDB. Since VFP cannot be run outside of windows there is no need to support installations on a non-Microsoft platform, so there is no need for an ODBC driver. The OLEDB Provider for Visual FoxPro is fully compatible with VFP Version 9/0 and introduces many useful features not available to the ODBC driver. Check the help files for details under the topic:
How to: Access Visual FoxPro Data in Visual Studio
Which includes a lot of good examples