Hello, I am doing a project where I am using Access along with a linked table from SQL server using ODBC source.
The data is being put in to the table by using a module in access with VBA code. The VBA code uses a select query that has been created before running the module. After going through the first 43 records, I get the ODBC insert on table failed. Any ideas how I can get pass this?
The current driver for the ODBC is SQL Server and not SQL Server Native Client 11.0. I did try SQL Server Native client but I was getting the ODBC Call Failed error.
I've been messing with the Execution Timeout connection time. Nothing seems to work.
The table from the SQL side comes from a Database that is password protected and I do have admin rights.