How to setup read-write table on sharepoint 365?

Question

I have Office 365 Small Business Premium.
I login in office 365 Small Business Premium.
Then I went to sites >> site team >> add a app >> then I choose Access APP >> gave a name to it and it show up on Site Contents page >> then I clicked on it >> show me a page where says:
Well done! You've successfully created an Access app. Now it's time to start designing. Start by adding some tables in Access.
Then I clived on: Open this app in Access to start adding tables.
>> access 2013 opened to me and I created a simple table 
>> then clicked on : launch app view that send me to Internet explorer with the table opened on the web APP >> then I added two recordas on table.
>> clicked on customize in Access >> access opened >> I clicked on file >> then clicked on REPORT ON MY DATA >> gave a name to it and saved in a local folder >> Access opened it >> I try to change/update one field record on table and it show me the error.
I checked connections manage and read=write connections are enable.

ODBC –update on a linked table ‘servicos’ failed.
[Microsoft] [SQL Server Native Cliente 11.0] [SQL Server]The UPDATE permission was denied on the object ‘servicos’, database ‘db_88a642ce_7d42_4568_8ebc_85a54131d38c’, schema ‘Access’. (#229)

---

Umesh S

Answer 1

Hi, Umesh Subramaniyam

This forum is for developers mainly discussing issues about Office add-in, to fix this issue, I suggest that you can reopen a new thread in Stack Overflow tag your question with [Office365] and [API].

The reason why I recommend posting appropriately is you will get the most qualified pool of respondents, and Office 365 developer team will also monitor the tag regularly. 

Hope it is helpful.

Regards

Deepak

---

We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place. <br/> Click <a href="http://support.microsoft.com/common/survey.aspx?showpage=1&scid=sw%3Ben%3B3559&theme=tech"> HERE</a> to participate the survey.

Answer 2

I think tables in the Access schema are never updatable. They are like the old MSys* tables.

Try it with your own table.

---

-Tom. Microsoft Access MVP