背景

上一篇《Using SQL Server DB for DSC》中，核心機(jī)制就是這個(gè)圖：

成都創(chuàng)新互聯(lián)主營辛集網(wǎng)站建設(shè)的網(wǎng)絡(luò)公司,主營網(wǎng)站建設(shè)方案,重慶APP軟件開發(fā),辛集h5微信平臺(tái)小程序開發(fā)搭建,辛集網(wǎng)站營銷推廣歡迎辛集等地區(qū)企業(yè)咨詢

我一開始的理解是這樣的，并且很長時(shí)間這么理解

還驚訝于“雙向同步”的設(shè)計(jì)。
其實(shí)并不是這樣的

Access Linked Table

When you link to a table in an Access database, Access creates a new table, called a linked table, which maintains a link to the source records and fields. Any changes you make to the data in the source database are reflected in the linked table in the destination database, and vice versa.
https://support.microsoft.com/en-us/office/import-or-link-to-data-in-another-access-database-095ab408-89c7-45b3-aac2-58036e45fcf6#Link to data in another Access database

Although linked tables can be used as regular Microsoft Access Database tables, it’s important to keep in mind that they aren’t actually stored in the Microsoft Access database. Each time data is viewed in a linked table, Microsoft Access has to retrieve records from another file. This can take time, especially if the linked table is on a network or in an SQL database.
http://www.eident.co.uk/2017/03/performance-microsoft-access-databases/

所以，Access本身并不存儲(chǔ)數(shù)據(jù)，只是通過ODBC driver發(fā)送數(shù)據(jù)庫操作到SQLServer。當(dāng)你打開.mdb文件看到數(shù)據(jù)是因?yàn)樽隽艘淮尾樵兌选?br />

名稱欄目：AccessDB-UsingSQLServerDBforDSC-創(chuàng)新互聯(lián)
當(dāng)前URL：http://weahome.cn/article/cddcos.html