I don't think that SPT vs remote views are a problem or the VFP version. (Although, check to make sure that the Transactions setting is set to AUTO.) I beleive it is an issue with permissions.
My suggestion would be to create a user role that is also a member of the db_datareader and db_datawriter but the permissions on the necessary tables for delete/insert are explicitly set.
Richard
>AFAIK, these tasks are covered in the db_datareader, db_datawriter roles: everyone in the group successfully enters and deletes records in the course of their daily activities.
>
>The only real differences, from my perspective anyway, are that 1) the monthly close application uses exclusively SPT whereas the app in daily use has a mixture of remote views and SPT, and, 2) the primary task of the close is inserts and deletions rather than edits. Oh, there is one other difference: the close is written in VFP 8 while the other app is in VFP 7.
State of Florida, DCF