I am in the early stages of building a db for my company. Since we operate out of various locations I am experimenting with linking a backend on sharepoint (or an sql server if necessary)
Creating the linked sharepoint lists has not been a problem however now I find that I do not know how to add a field to a linked table/list. The sharepoint admin centre does not seem to offer any access to editing the lists. I have tried Converting to a local table, adding my new fields but now if I try to re-export the table, Access tells me that "if there is a list with this name, a number will be appended to the name of the new list."
My question is:
- Can I edit the list/table directly on sharepoint?
- Or - Can I (How do I) delete a list on sharepoint, edit a local copy and re-export?