>>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,>>

There's no autoincrement field type of a native dbf file, unless youre using VFP8 or the VFP9 beta...

When you say Native DBF, do you mean Dbase, foxpro dos?