I am building the application in windows forms with MS Access 2007. Can any body help to sort out the problem of i.e. "Operation must use an updateable query"
Thanks in Advance!
Chances are, your SELECT query isn't returning the primary key of the table you're querying. You DO have a primary key column in the table, right?? If not, you better create one.
Without the Primary Key column, there's no way to uniquely identify every record in the table, which allows UDPATE and DELETE sql statements to find those records.
That's why you're getting the error message...
Microsoft Access does not support the full T-SQL instruction set that might be the problem. I encountered that trying to use IF EXISTS(.... on an MS Access Database.
Plz Write you query string to understand the problem
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)