Access Web Database Datasheet form not rendering
Someone in my company is attempting to build an Access Web Database that includes a datasheet form. After deployment, everything works well except the datasheet form. This form won't render. I do see a JavaScript error "Unable to get property
'ColumnName' of undefined or null reference". When I click on the tab with the datasheet form on it, I see several Loading messages with spinners and then nothing. The page is blank. There is HTML inside the area where I would expect to see
the form but all the containers are empty. I'm guessing because of the JS error, not sure. Any help would be appreciated.
August 31st, 2015 6:02pm
Hi Robbertv
Could you offer a screenshot about your issue?
Before you design a form that contains a datasheet, you should review the relationships between your tables and add any relationships that are missing. Doing this enables Access to automatically create the links between datasheets and main forms.
I refer to the following article to insert a datasheet into a form and publish it to the SharePoint 2013 and it works fine.
Take a look at it:
https://support.office.com/en-us/article/Insert-a-datasheet-into-a-form-8a14cecd-7459-47df-9d46-10ee26c2fd1b
Best Regards,
Lisa Chen
Free Windows Admin Tool Kit Click here and download it now
September 6th, 2015 10:06pm