I want to use the ACCESS link several table implementation can update the contents of this a few tables to ACCESS, but I'm in the changes on the ACCESS is not synchronous to the SQL SERVER, excuse me what method can be implemented?
CodePudding user response:
With a program built adp access2003,CodePudding user response:
Adp project in 2007 and later was gone,CodePudding user response:
Adp can support to Access2010, Access is no longer support the adp project after 2010,If using Access as a receptionist, SQL server as a background (a typical C/S architecture), you can use the link table, link table is through ODBC to connect to SQL server, how to do link bracelet received a SQL server database, a lot of online information, you can look up, his is actually through a wizard, links, can like to operate local Access the data in the table, the table updates will be an update to the background of SQL server database, but seems can not change the structure of a table fields (such as add or delete a table).