Error Number 3326
Pictures & Albums Members List Calendar Search Forums Show Threads Show Posts Tag Search Advanced Search Find All Thanked Posts Go to Page... Thread Tools Rating: Display Modes 06-03-2007, 08:34 PM #1 Crash_Pie Registered User Join Date: Feb 2007 Location: New Zealand Posts: 36 Thanks: 0 Thanked 1 Time in 1 Post Runtime error 3326 Not quite sure where to put this one, as I don't know if it is a query issue, coding, or just form design? I have attached a cut down copy of my database and the problem lies with when I try to update a date field in the subform. To replicate the error, open the mainform, choose "Daily" & "Overdue". The subform should then appear with an "update" button next to the data. If you then choose update and select "yes" what should happen next is the "AssetDateLastSchedMaint" (long name I know) field should then be updated with todays date, the query rerun and all should be fine and dandy. But, as usual I have run into a problem. When I choose to update the date I receive the error: "Runtime error 3326, This recordset is not updateable". I actually based this form, subform, query and code on another in the same database and they all work fine . Could someone have a look for me and point out to me how to fix it. Thanks in advance. Attached Files CutDown.zip (55.3 KB, 183 views) Crash_Pie View Public Profile Find More Posts by Crash_Pie 06-04-2007, 10:51 AM #2 Crash_Pie Registered User Join Date: Feb 2007 Location: New Zealand Posts: 36 Thanks: 0 Thanked 1 Time in 1 Post Runtime error 3326 - Recordset is not updateable Should I be trying to update the table directly and not via the form? Crash_Pie View Public Profile Find More Posts by Crash_Pie 06-04-2007, 11:36 AM #3 MarkK Super Moderator Join Date: Mar 2004 Location: Vancouver BC Posts: 6,366 Thanks: 4 Thanked 932 Times in 892 Posts The query that drives the subform is not updateable. Open the query in design view and unclick the summation button on the toolbar. This is the large backwards E. Note that the "Group By" modifiers disappear? Save the query. Retry your process. Note that the subform now shows the data but also allows you to add a new record? To suppress this behaviour, set the subform's AllowAdditions property = false. __________________ formerly known as lagbolt | Windows 7 | Access 2010 | Visual Studio 2013 | To view links or
DriverDoc WinSweeper SupersonicPC FileViewPro About Support Contact Errors Troubleshooting › Runtime Errors › Microsoft Corporation › Microsoft Access › Error 3326 How To Fix Microsoft Access Error 3326 Error Number: Error 3326 Error Name:Microsoft Access Error 3326 Error Description: This Recordset is not updateable. Developer:Microsoft Corporation Software:Microsoft Access Applies to:Windows XP, Vista, 7, 8 Download NowWinThruster 2015 - Scan your PC for computer errors. Compatible with Windows 10, 8, 7, Vista, XP and 2000 Symptoms http://www.access-programmers.co.uk/forums/showthread.php?t=129408 of Error 3326 "Error 3326" appears and crashes the active program window. Your PC frequently crashes with Error 3326 when running the same program. “Microsoft Access Error 3326” is displayed. Windows runs sluggishly and responds slowly to mouse or keyboard input. Your computer periodically “freezes” for a few seconds at a http://www.solvusoft.com/en/errors/runtime-errors/microsoft-corporation/microsoft-access/3326-microsoft-access-error-3326/ time. These 3326 error messages can appear during program installation, while a Microsoft Corporation-related software program (eg. Microsoft Access) is running, during Windows startup or shutdown, or even during the installation of the Windows operating system. Keeping track of when and where your 3326 error occurs is a critical piece of information in troubleshooting the problem. Causes of Error 3326 Corrupt download or incomplete installation of Microsoft Access software. Corruption in Windows registry from a recent Microsoft Access-related software change (install or uninstall). Virus or malware infection that has corrupted Windows system files or Microsoft Access-related program files. Another program maliciously or mistakenly deleted Microsoft Access-related files. Runtime Errors such as “Error 3326” can be caused by a variety of factors, so it is important that you troubleshoot each of the possible causes to prevent it from recurring. Runtime Errors Knowledgebase Article ID: 126068 Article Author: Jay Geater Last Updated: 19-07-2016 Popularit
Join INTELLIGENT WORK FORUMSFOR COMPUTER PROFESSIONALS Log In Come Join Us! Are you aComputer / IT professional?Join Tek-Tips Forums! Talk With Other Members Be Notified http://www.tek-tips.com/viewthread.cfm?qid=148924 Of ResponsesTo Your Posts Keyword Search One-Click Access To YourFavorite Forums Automated SignaturesOn Your Posts Best Of All, It's Free! Join Us! *Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail. Posting Guidelines Promoting, selling, recruiting, coursework and thesis posting is forbidden.Tek-Tips Posting Policies Jobs Jobs from Indeed What: Where: jobs by error number Link To This Forum! Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.Just copy and paste the BBCode HTML Markdown MediaWiki reStructuredText code below into your site. Microsoft: Access Forms Forum at Tek-Tips HomeForumsProgrammersDBMS PackagesMicrosoft: Access Forms Forum Run-time error 3326 thread702-148924 Forum Search FAQs Links MVPs Run-time error 3326 Run-time error 3326 dvannoy error number 3326 (MIS) (OP) 15 Oct 01 11:25 I have a form based off a query. It's been running fine for months..all of the sudden i am getting the Following message.. Run-time Error 3326 This Recordset is not updatable...what would casue this?? and how can i fix it..Thanks DVannoy A+,Network+,CNAdvannoy@onyxes.com RE: Run-time error 3326 pcdaveh (TechnicalUser) 15 Oct 01 12:54 I'm assuming that this form is somehow connected to a query.I'm not sure if your using bound or unbound controls but whatever query your using try making this change.In the query properties Record set Type make sure it is set to: Dynaset (Inconsistent Updates.) RE: Run-time error 3326 dvannoy (MIS) (OP) 15 Oct 01 13:07 Thanks...that worked...but why all of the sudden would that be an issue?? I could not find any info on Microsoft's web site.. DVannoy A+,Network+,CNAdvannoy@onyxes.com RE: Run-time error 3326 pcdaveh (TechnicalUser) 15 Oct 01 14:58 I'm not really sure without seeing it and knowing the full history.I myself had the same question a few years ago and someone helped me.I just know it