mysql
1 Topic
Unable to insert records in Linked table from MS Access to SQL Server
Hi, I have created an MS Access project in 2007-2016 format. The OS is Windows 11. For POC purpose it is a simple form with ID as Autonumber and Name1 with short text fields. Now I am trying to link the MS Access to sql server table. For this I have selected ODBC driver 17 for sql server. First I exported table from ms access to sql server to create the table copy in sql server. Then added Primary Key in sql server table. Then I have right clicked table in MS Access and selected Linked Table Manager to select the table in sql server. On adding new record and save in ms access form, the table in ms access is adding new records but sql server is not. Earlier while exporting the data was exported successfully but after linking table new records are not getting added.Solved1.3KViews0likes5Comments