MySQL

2 Topics

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.
Solved
siddharth10975
Apr 09, 2024 Place Access
1.4KViews
0likes
5Comments
Installed MySQL connector/NET 8.0.13 but still doesnt connect in Excel 2016
I'm trying to connect to MySQL database using Data > New Query > From Database > From MySQL Database However i am getting the error "This connector requires one or more additional components to be installed before it can be used" I have already installed the MYSQL Connector/NET 8.0.13 But i continue to get the error box in Excel I am using Excel 2016, 64 bit, with Professional Plus 2016 Any help would be appreciated thanks very much
Karlena Bucknor
Jan 02, 2022 Place Excel
17KViews
0likes
3Comments