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?
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?
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.