Access Web app does not save data edits

Question

I have found what I consider a bug when a web app Datasheet View does not save the edit you make to a LOOKUP field. This happens for both lookups to another table and a Value list.

Here is how to reproduce the problem.

• Select a Datasheet View that has a Lookup field
• Click directly on the Lookup field
• Delete the current value OR select another value via the Find feature for table Lookups, the dropdown for Value List.
• Now, click to select a different view from the navigation pane on the left OR switch to a List view for the same table.
• The app does not save your change. Nor does it prompt you to save.

Note that if you TAB or click somewhere in the same Datasheet View, your change WILL be saved and/or you get prompted to save. The problem only occurs if you click for a different view. List Views do not appear to have the same problem.

PS: I am using an Office 365 online account with SharePoint & Access web apps enabled. I don’t have a on premises SharePoint to try this on.

---

Jim Brown

Answer 1

I made a test, and I could reproduce your issue.

For entering data in DataSheet, I would suggest you TAB to save the record.

For this issue, I would suggest you submit a feedback in the link below:

https://access.uservoice.com/

---

MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact [e-mail].

Answer 2

Yes, it's a operator training thing. They need to know to TAB or click on the same form to ensure changes get saved.

As for submitting to uservoice.com its a mute point as I understand they are dropping Access Web apps in favor of PowerApps. That stinks as I had just completed and deployed the solution where this issue came up.

---

Jim Brown

Answer 3

It is sad Access web app will be end of support. 

I would suggest you refer the link below for migrating Access web app.

#Access Services in SharePoint Roadmap

https://support.office.com/en-us/article/Access-Services-in-SharePoint-Roadmap-497fd86b-e982-43c4-8318-81e6d3e711e8

---

MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact [e-mail].