Click here to Skip to main content
13,152,454 members (38,325 online)
Rate this:
 
Please Sign up or sign in to vote.
Hello,
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!
Posted 23-Feb-12 2:11am
Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 1

Check this[^] it'll help you
  Permalink  
Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 5

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...
  Permalink  
Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 4

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.
  Permalink  
Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 2

Plz Write you query string to understand the problem
  Permalink  

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month


Advertise | Privacy |
Web03 | 2.8.170924.2 | Last Updated 6 Mar 2012
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100