Why do I get *Cursor is read-only* with VFP Data in ASP.NET?

When using the INSERT or UPDATE commands from within an ASP.NET application that access VFP data, you may get the error "Cannot update the cursor <Table Name>, since it is read-only." This is probably due to a lack of permissions.

To fix this problem, you need to specify rights for your ASP.NET user account (usually ASPNET) to have read/write access to that particular directory as outlined in these steps:

In Windows Explorer, right-click the folder that contains the VFP data, and select Properties from the shortcut menu.

In the Properties dialog, select the Security tab.

1. Click the Add button to add the ASPNET (or other user) to the list of users.

2. In the Select Users or Groups dialog, enter ASPNET in the text box.

3. Click the Check Names button, which may add a machine name prefix to the user name

4. Click OK to add the new user

5. In the Properties dialog, select the new user in the list, and select the Full Control check box to give full rights to the user.

6. Click OK to save changes