Updating links in access
You will also need to manage your linked tables if you move your current back end to a new location.
When you've linked an Access Database to Share Point lists, how do you make sure that saving the database updates the existing list instead of creating a new one, so that lookup columns pull from the up-to-date list?
Here's the specific problem I experienced: I used the "Move To Share Point" command from Access to link the database to Share Point.
Edit: In the menu where you choose your site choose the option to link and not to import the data.
Once you have learn how important it is to Split your Access database into application and data you will need become very good at managing your linked tables.
In theory, I could delete the old "Components" list and rename the new "Components_1".
This is important if you want to be able to switch to a different back end.
I am regularly switching between live data (back end) and test data (back end).
If I delete "Components," I will lose all that information.
What I need to be able to do is update "Components" on Share Point so that I can select the new items from the lookup column in the Pictures Library. Choose "Microsoft Share Point Foundation ()" in the list of document types.
It created the appropriate lists on the Share Point site, and in Access those now show up as linked tables (the icon is gold).
However, when I added new entries to the table and saved the changes instead of updating the "Components" list, a new list "Components_1" was created.