Hi Robert,
Thank you for responding. The three things you mentioned: Manager privileges of the database - done. Register the database with the server - done. The Feature template I have not done because I thought that was for creating records. We will only be updating tables. Anyway, still no luck. To further explain, we are using a SQL database with tables AND views. The views are also in the map document. So obviously our web application has the SQL views in it. We think maybe the issue is because we can't update a sql view? We want to be able to update the sql tables that the views are based on.
So when I am creating a Service, I choose Feature Access and uncheck Create and Delete, but leave Update. Then Analyze. Here is the error I am getting: "Enabled Feature Access capabilities do not match feature layer user privileges." All of the items listed come from the sql views and not the sql tables.
Does Feature Access allow for defining what is to be updated and what is not?
Any ideas? I appreciate your help!
Thank you!