Hi Denise,

Like Jim said, forget ZAP. Sure it works on the local view, but it is unsupported via ODBC. It won't work on the server side. I ran into this one a few years ago with a SQL Server back-end application.

See you at the FUG in a few weeks (sorry I missed the last meeting).


>I'm back in the real world, finally!!!! Back on a Fox 5.0 project. That's the good news :)
>
>Now for the bad news... I need help, please. I have this view of an Access table. When the client imports new data the code is supposed to zap the data already in the table and overwrite it with the new stuff. Zap isn't working. It's not producing an error message or anything, and it looks like it works (cycles through the records, I can see it happening becuase it's a very large table) but it doesn't get rid of them, becuase when the new stuff comes in now I have double the records that I'm supposed to have.
>
>I thought views were supposed to make it so that Foxpro commands could work through the ODBC and do whatever it was supposed to do in the Access table. Obviously I'm wrong. Could someone please give me a clue as to how to fix this problem? Thanks!!
>
>BTW -- nice to rejoin y'all in the real world :)