Access the access chain table!

Perform secondary development on the customer's system. Their system is developed using access VBA. Now we need to perform secondary development on their system and use the original database.

Access has the concept of a chain table, that is, it can be linked to other data in a data table, and then managed in a unified manner in a database. When you open such a chain table with VB, it cannot be opened.
It was confirmed that the customer's network system was in the domain because VB did not support such a chain table. My computer was not added to the domain and did not have the permissions for those chain tables. later, you can log on to the domain from the local machine.

Previously, I only knew that SQL Server has the concept of linking to the original server. Data calling between different servers does not need to change the connection string. Access also has this function.