You can't do it with ODBC. The ODBC driver was last updated in VFP 6.0. It knows nothing about AutoInc fields.
>Hello everyone, I have a concern on how to create a remote view of a DBF native table with a field that is of [integer] auto-increment datatype because every time i attempt to create a remote view an error message occurs: "CONNECTIVITY ERROR [MICROSOFT][ODBC VISUAL FOXPRO DRIVER] NOT A TABLE."
>
>But if I changed the data type of this field to numeric, no error message occurs when creating a remote view.
>
>I hope someone can help me on this.
>
>Thanks and regards,
>
>Marlon Estrelon
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer