You can verify if the table is enabled for CDC by looking into the Execute the script below to enable CDC on the above created table.
Large updates become much easier to perform when you understand some of the basic principles of database design.
An Access database is not a file in the same sense as a Microsoft Office Word 2007 document or a Microsoft Office Power Point 2007 slide deck.
A database snapshot provides a read-only, static view of a source database as it existed at snapshot creation, minus any uncommitted transactions.
Uncommitted transactions are rolled back in a newly created database snapshot because the Database Engine runs recovery after the snapshot has been created (transactions in the database are not affected).
In turn, those design principles affect how you enter data.
Remember these facts about database objects and design as you proceed.
If you continually loop over a table using a cursor, locking one row at time, the lock promotion to lock the whole table when the lock escalation point is reached.
If this attempt fails because there is another lock which prevents the escalation, the attempt is aborted and individual page locking continues.
Then I talked about how it differs from Change Tracking.