I have added a connection to a couple of Azure SQL databases using a SQL account that is db_owner on both databases. However, for some reason when I add an edit form for one of the databases all the fields show as view. I can go into each individual field and change from view to edit but it makes no difference.
I'm not sure why this is happening as the account used for the connection is a db_owner and it works fine on the other database.
Has anyone come across this before, and if so, how can I fix it?
Thanks in advance for your help.
Solved! Go to Solution.