Operation Must Use An Updateable Query Error In Asp.net
360 games PC games Windows games Windows phone games Entertainment All Entertainment Movies & TV Music Business & Education Business Students & educators Developers Sale Sale Find a store Gift cards Products Software & services Windows Office Free downloads & security Internet Explorer Microsoft Edge Skype OneNote OneDrive Microsoft Health MSN Bing Microsoft Groove Microsoft Movies & TV Devices & Xbox All Microsoft devices Microsoft Surface All Windows PCs & tablets PC accessories Xbox & games Microsoft Lumia All Windows phones Microsoft HoloLens For business Cloud Platform Microsoft Azure Microsoft Dynamics Windows for business Office for business Skype for business Surface for business Enterprise solutions Small business solutions Find a solutions provider Volume Licensing For developers & IT pros Develop Windows apps Microsoft Azure MSDN TechNet Visual Studio For students & educators Office for students OneNote in classroom Shop PCs & tablets perfect for students Microsoft in Education Support Sign in Cart Cart Javascript is disabled Please enable javascript and refresh the page Cookies are disabled Please enable cookies and refresh the page CV: {{ getCv() }} English (United States) Terms of use Privacy & cookies Trademarks © 2016 Microsoft
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping each other. Join them; it https://support.microsoft.com/en-us/kb/175168 only takes a minute: Sign up Operation must use an updatable query. (Error 3073) Microsoft Access up vote 17 down vote favorite 4 On some Microsoft Access queries, I get the following message: Operation must use an updatable query. (Error 3073). I work around it by using temporary tables, but I'm wondering if there's a better way. All the tables http://stackoverflow.com/questions/170578/operation-must-use-an-updatable-query-error-3073-microsoft-access involved have a primary key. Here's the code: UPDATE CLOG SET CLOG.NEXTDUE = ( SELECT H1.paidthru FROM CTRHIST as H1 WHERE H1.ACCT = clog.ACCT AND H1.SEQNO = ( SELECT MAX(SEQNO) FROM CTRHIST WHERE CTRHIST.ACCT = Clog.ACCT AND CTRHIST.AMTPAID > 0 AND CTRHIST.DATEPAID < CLOG.UPDATED_ON ) ) WHERE CLOG.NEXTDUE IS NULL; ms-access share|improve this question edited Oct 4 '08 at 21:46 Sklivvz♦ 20.5k2381152 asked Oct 4 '08 at 16:08 Knox 2,00872655 add a comment| 20 Answers 20 active oldest votes up vote 20 down vote accepted Since Jet 4, all queries that have a join to a SQL statement that summarizes data will be non-updatable. You aren't using a JOIN, but the WHERE clause is exactly equivalent to a join, and thus, the Jet query optimizer treats it the same way it treats a join. I'm afraid you're out of luck without a temp table, though maybe somebody with greater Jet SQL knowledge than I can come up with a workaround. BTW, it might have been updatable in Jet 3.5 (Access 97), as a whole lot of queries were updat
Tips/Tricks Top Articles Beginner Articles Technical Blogs Posting/Update Guidelines Article Help Forum Article Competition Submit an article or tip Post your Blog quick answersQ&A Ask a Question View Unanswered Questions View http://www.codeproject.com/Questions/442585/operation-must-use-an-updateable-query-ms-access All Questions... Linux questions C# questions ASP.NET questions SQL questions fabric questions discussionsforums http://www.beansoftware.com/ASP.NET-FAQ/Operation-Must-Use-An-Updateable-Query.aspx All Message Boards... Application Lifecycle> Running a Business Sales / Marketing Collaboration / Beta Testing Work Issues Design and Architecture ASP.NET JavaScript C / C++ / MFC> ATL / WTL / STL Managed C++/CLI C# Free Tools Objective-C and Swift Database Hardware & Devices> System Admin Hosting and Servers Java .NET operation must Framework Android iOS Mobile SharePoint Silverlight / WPF Visual Basic Web Development Site Bugs / Suggestions Spam and Abuse Watch features Competitions News The Insider Newsletter The Daily Build Newsletter Newsletter archive Surveys Product Showcase Research Library CodeProject Stuff communitylounge Who's Who Most Valuable Professionals The Lounge The Insider News The Weird & The Wonderful The Soapbox Press Releases Non-English Language > General Indian operation must use Topics General Chinese Topics help What is 'CodeProject'? General FAQ Ask a Question Bugs and Suggestions Article Help Forum Site Map Advertise with us About our Advertising Employment Opportunities About Us Ask a Question All Questions All Unanswered FAQ operation must use an updateable query ms access Rate this: Please Sign up or sign in to vote. See more: C#3.0 C# Hiiii to all i have completed my windows application. I created the setup of my project but when its setup runs,it shows an error in my first form.Actually i am using acess2003 database as a local database. and uses the following connection string OleDbConnection con = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|/Furniture.mdb"); i m using windows7 as OS and my system is 32bit system. it show me the error Operation must use an updateable query i search a lot and change the security setting of database file but still it shows the same prblm... plz help Posted 17-Aug-12 20:15pm Member 82336011.3K Updated 17-Aug-12 20:42pm Mehdi Gholam325.5K v2 Add a Solution 4 solutions Top Rated Most Recent Rate this: Please Sign up or sign in to vote. Solution 2 Accept Solution Reject Solution One quite lik
Control SEO Pager Highlighter Shortcut Controls Crypt Package Free ASP.NET Controls Geotargeting Component ASP.NET Media Player Control Flash Video Player Control Services ASP.NET Telecommute Jobs Free IP Location Lookup Test .Net Regular Expressions CSS/Table/DIV Page Layouts Custom Programming Article Sites Master List Articles dev.beansoftware.com ASP.NET Tutorials ASP.NET FAQ T-SQL FAQ HTML/CSS FAQ .NET Windows Forms General .NET Framework Freelance Tutorials Web Domains Accepting Credit Cards Anti Spam Home Shop Advertise Write For Us Affiliate Newsletter Contact Solve Operation Must Use an Updateable Query Error in Access MS Access database can be used as data storage of dynamic web sites. Sometimes, when you try to update existing or add new records, you will receive the "Operation must use an updateable query" error. Error details could be like this: Operation must use an updateable query Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.OleDb.OleDbException: Operation must use an updateable query. This error description is not very useful, because if you look to your SQL query it is probably correct. The reason for this error is usually one of few reasons: Web application has not write permission in folder where MS Access database is located To update records, you need to write changes to .mdb file on disk. If your web application can't write to disk, you can't update existing or add new records. So, enable read/write access in database folder or move database to other folder where your application has write permission. Database file has ReadOnly attribute If .mdb file is Read Only, then you can't write to it. So, to enable updating and inserting