schaIT
asked on
Error 3184 Could not execute query; could not find linked table
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:
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!
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
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!
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Then, as lludden wrote above, check the permissions on that table. If you can View but not INSERT/UPDATE, then you would have to assume permissions.
ASKER
A trigger permission in the table on the server was causing the issue. I removed the trigger since it was no longer needed and now all is well. Thank you for your help and my apologies for not closing the question sooner.
Thanks again!
Thanks again!
ASKER