I have a Access 2000/VBA application. It interfaces with linked tables that are resident on a SQL Server. The application has been interfacing fine with the linked tables for about a month, but today it has started throwing the following error.
3156 ODBC Delete on a linked table failed.
Nothing has changed programming wise or database wise to this application.
What I've been doing to resolve the issue is stopping the SQL Server service and restarting it. After that the application resumes it's normal function.
Anything I can do to fix it rather than starting and stopping the service?