MSAccess delete query
-
I tried to run the delete query in MS Access(.mdb) database which is connect with SQL server as a system dsn connection. But i can't run the query and i check with the table view. In table view, i also can't delete as i could not found the delete current record command is enabled.Other tables are OK as i can delete in table view. But only some table that i can't. I checked already in SQL server table properties as they give a permission of delete to that table by specified sql DB users.
How can i solve the problem, please? Thank you for your helpful suggestion.
-
Please check and ensure that the table has a PRIMARY KEY. Most of the time this is the problem
PS. You will need to re-link the table(s) after the change in SQL to pick up the schema change
Good Hunting!AJ Ahrens
webmaster@kritter.net -
Thank you so much. Now it's work.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply