Updating access database with
Update the DB locally and the move the DB back to its network location.Here are a few explicit steps: Step 1 – Move DB to Local HDD: Move the CC DB to the local HDD (refer to the Locating Database and Move Database help topics).I would suggest start with the BOL: there are good working examples.Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.Refer to the Update a SQL Server Database help topic for SQL Servers.Revisions of CC often require / make changes to the structure of the DB.
This is say 400 MB round up, if my math is correct.
In theory, I could delete the old "Components" list and rename the new "Components_1".
However, I have a picture library with a lookup table that links items and components to their pictures.
It’s important to understand the backup process (above) since an update activity may fail / freeze at any point.
Therefore, the backup process may need to be re-started.
Visit Stack Exchange 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?