In the organisation we have an application that was developed using VB 6 and access 2003, the database is on SQL 2005 and is currently running on windows server 2008.
We migrated the application to another server which is running windows server 2012 and also on the Database is SQL server 2017.
The application is working on the new environment the only challenge we have is when we insert the new record on the database, am get this error “3155 ODBC – insert on a linked table ‘Table name’ failed.” Can you please help.
What I have tried:
I tiered to relink the tables from database to the application but it still give me the same problem.