September 9, 2016 at 11:49 am
I have an Access front end and an ODBC SQL Server (2012) front-end seemingly with permissions issues in one specific table. In Access the user gets this message when trying to delete a record from a form in Access "Cannot Delete from Specified Table".
I cannot delete even when opening the table directly - in Access but I can write a T-SQL delete statement that works fine. Thanks for any help all. I've looked at all the permissions I can think of at a user level, table level, MS-Access level, etc.
September 9, 2016 at 12:37 pm
briancampbellmcad (9/9/2016)
I have an Access front end and an ODBC SQL Server (2012) front-end seemingly with permissions issues in one specific table. In Access the user gets this message when trying to delete a record from a form in Access "Cannot Delete from Specified Table".I cannot delete even when opening the table directly - in Access but I can write a T-SQL delete statement that works fine. Thanks for any help all. I've looked at all the permissions I can think of at a user level, table level, MS-Access level, etc.
Your getting an Access error, not a SQL Server error. You'd need to look at the delete statement that the Access front end is sending across since there are some access type of things that can cause the error. I don't remember many of those Access issues - needing a unique identifier, not using distinctrow with delete are a couple of the things I can think of.
Since the T-SQL works fine, you need to look how Access is doing it differently. I would look at that before any permissions issues.
Sue
September 9, 2016 at 12:48 pm
maybe this post will help....seem to remember similar problems, but cant remember the solutions!
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply