Well.. that won't work. You can't ZAP a remote table. ZAP only works on VFP tables & cursors.

I suggest you do some reading. Start here https://msdn.microsoft.com/en-us/library/y0d2h945(v=vs.80).aspx



>Thanks.
>
>The view is now in the DBC. Now I have the following problem:
>
>I basically want to ZAP the remote table and APPEND from the latest local data. So this is my code:
>
>

>OPEN DATABASE blarg    &&contains the views
>USE v_table1                     &&the view
>ZAP
>APPEND FROM local_table1
>USE
>

>
>The trouble is that when I try to USE the view, I get a window asking me to enter the password for the SQL Server database. I thought that was taken care of by the ODBC connection?!
>
>How can I bypass that window?
>
>Thanks,
>
>Yossi