Good afternoon! Any help on this would be greatly appreciated.
I made some changes to a table in a database on SQL Server. The table is connected to a Microsoft Access front end. I updated the linked tables to include the changes made on the server. When I run my code in the front end to add a record to the table, I get the following error message:
I have tried the following to resolve the issue:
Remove the linked table and add it back
Perform a compact and repair on the front end
Create a new front end and import the tables from the server
None of the above has cleared the error. I may have missed a step in fixing the error.
Thanks in advance for any advise or suggestions!