Just to be sure I know what you want, do you want to add records WITHOUT using remote views?
>I have been able to UPDATE my records but I can't ADD a new one.
>Since I am new with ODBC I have created a form with a remote view
>and then I am using the Wizard buttons to do the rest.
>
>Can you send me some sample code about Adding, deleting, updating,
>etc through ODBC?
>
>Thank you again
>
>
>
>>We use VFP to add data to SQL Server tables all the time. What's the specific problem?
>>
>>>Is there a limitation about adding records from Visual FoxPro?
>>>
>>>I can't add a new record to Access or SQL tables.
>>>
>>>Any suggestions or comments will be welcome
>>>
>>>Thank you in advance.
"It is an important and popular fact that things are not always what they seem. For instance, on the planet Earth, man had always assumed that he was more intelligent than dolphins because he had achieved so much -- the wheel, New York, wars and so on -- whilst all the dolphins had ever done was muck about in the water having a good time. But conversely, the dolphins had always believed that they were far more intelligent than man -- for precisely the same reasons." - Douglas Adams