Hey all,
If anyone could help save my job, I will have a pizza delivered to your doorstep.. I am having 2 issues.
1.) I exported about 9 tables to sharepoint. But for 2 tables there were duplicates created in SP. For instance, "Project_tbl" Created in sharepoint, "Project_tbl", "Project_tbl_1", "Project_tbl_2", "Project_tbl_3"..., "Project_tbl_7".
This doesn't seem to effect when I enter data in the Access mainform/subform. It only updates the Project_tbl List in Sharepoint. I just want to make sure this is okay and it's not the cause of the 2nd issue I'm having.
2.) So the mainform/subform works for both FE and BE, But on the sub-sub form whenever I try to enter data I get "Cannot Update. Database or Object is read-only".
*Note this database worked flawlessly until I started exporting to SP
Things I have tried:
- Compact & Repair
- Both Refresh and relink Tables to SP
- Copy and paste into a blank database
- Options>Current Database>Caching web Services and Sharepoint tables> Uncheck "Use the cache format....", also tried checking "never cache" ------> This creates a new message error when entering data "You cannot reference rows created when you are disconnected from the server because this violates the lookup settings defined for this table or list. Please reconnect all tables with the server and try again"
- Checked administrative restrictions in Sharepoint.
Any help is much appreciated, Thanks friend.