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
>USE v_table1
>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
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer