Josh:

Thanks for the reminder to get back to basics!

I did do as you suggest, and I'm now more confused than ever. It works in the command window.

Is it possible that I need to do a specific open of the database? I've always assumed (and never run into a problem) that the dataenvironment opens and closes the necessary databases and connections.

>
>I would start by simplifying your test a bit. Just USE the view in the command window and browse it. Make a change and try a TABLEUPDATE(). If TABLEUPDATE() returns .F., use AERROR() to see what error the ODBC driver returned.
>
>Make sure in the view designer that you've checked all the fields you want updated. Unless you're using identity fields you should include the key field(s) as fields that should be updated.
>