Hi!
In VFP, after you used tableupdate() for remote view, use aerror() function to see what error(s) exactly returned from SQL Server. Than post this error message(s) here, so we can help more, of course, if you don;t figure out problem by self using this approach.
HTH.
>I have a SQL Server 2000 installed on my laptop. W2K pro.
>
>I have access to the data, I can create remote views in VFP, but I cannot update data in them. When I point the view to the server at work, no problem. I know about updtate and how to do it.
>
>Same problem with VB on the local machine.
>
>So if figure that it's an install malfunction. Any ideas?
>
>__Stephen
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.