Marlon,

A remote view is normally for tables outside of VFP (e.g. MS SQL Server). Is there a reason you're using a remote view for native FoxPro tables? Otherwise, create a local view.

>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