Forum Discussion
Solved
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...
Actually, there are two things to consider:
- When you linked the Access accdb to the SQL Server tables, were you asked to identify the Primary Keys for those tables? Did you select the appropriate field in the SQL Server tables?
- Also, you still have both the Access table AND the SQL Server table? Why is that? Is your form still bound to the Access table, not to the SQL Server table? If not, how do you expect the data to be added to the SQL Server table?
Actually, there are two things to consider:
- When you linked the Access accdb to the SQL Server tables, were you asked to identify the Primary Keys for those tables? Did you select the appropriate field in the SQL Server tables?
- Also, you still have both the Access table AND the SQL Server table? Why is that? Is your form still bound to the Access table, not to the SQL Server table? If not, how do you expect the data to be added to the SQL Server table?
George Hepworth Thanks for your reply. Yeah I noticed it later that the form was still bound to the Access table and not the new linked SQL table. I had assumed on saving in Access it would update both since it's 'linked'.
"Linked" only means, that Access can see the table.
Bind your form to the linked table, and the form will read and write to that table.
- No. The form updates the table to which it is bound. Period.
Why do you want to keep duplicate tables, one a local Access table and the other a SQL Server table? The usual approach is that you do one or the other? What's the special requirement here?- Thanks, this was fixed.
