none
Corrupt Queries RRS feed

  • Question

  • I'm unsure if I'm having a corruption issue, or possibly something else.

    Only my queries are affected, my data and forms operate fine. A typical issue I'm having is if I open a single query in design view I'm fine, but if I open a second query in design view and toggle between queries I get huge lag (45 seconds) where my processor is just churning.

    I'm using Access 2013, I don't seem to be having the issue in 2007. Do queries get corrupted? Mostly I saw corruption related to tables and forms. This issue seems to effect even brand new queries, so I'm suspicious it could be related to the new software (recently moved to 2013) rather than corruption.

    Thursday, July 16, 2015 9:24 PM

Answers

  • It's possible that this fix, just out, may solve the problem for you:

    Fixes the following issues:

    • When you open multiple objects in design view and then try to switch to another view in Access 2013, Access 2013 may become unresponsive.
    • When you undo a column deletion operation in table design view in Access 2013, Access 2013 crashes.
    • The Conditional Formatting button does not work if the ribbon is collapsed in Access 2013.
    • After you import a form or report or you copy and paste an existing form or report in an Access app, the theme colors are changed unexpectedly under the control of the newly created form or report.

    If you are on Office 365 and get Access through your subscription, just use the Update Options button to get the latest updates. You should be using this version:
    https://support.microsoft.com/en-us/gp/office-2013-365-update
    15.0.4737.1003

    If you are using an MSI/boxed version of Access 2013, go here for the update:
    https://support.microsoft.com/en-us/kb/3054950


    Dirk Goldgar, MS Access MVP
    Access tips: www.datagnostics.com/tips.html

    • Marked as answer by w85 Thursday, July 16, 2015 11:16 PM
    Thursday, July 16, 2015 9:58 PM

All replies

  • I am not having the same results. I can open many queries in design view and don't have that issue. They switch in a fraction of a second. There may be something else going on with your hardware but the software does not perform that way under normal circumstances. Have you checked your task manager to see what is eating your memory? What environment are you working in? do you have all the updates installed? 32Bit/64Bit OS and Office?

    Just takes a click to give thanks for a helpful post or answer.
    Please vote “Helpful” or Mark as “Answer” as appropriate.
    Chris Ward
    Microsoft Community Contributor 2012

    Thursday, July 16, 2015 9:53 PM
  • It's possible that this fix, just out, may solve the problem for you:

    Fixes the following issues:

    • When you open multiple objects in design view and then try to switch to another view in Access 2013, Access 2013 may become unresponsive.
    • When you undo a column deletion operation in table design view in Access 2013, Access 2013 crashes.
    • The Conditional Formatting button does not work if the ribbon is collapsed in Access 2013.
    • After you import a form or report or you copy and paste an existing form or report in an Access app, the theme colors are changed unexpectedly under the control of the newly created form or report.

    If you are on Office 365 and get Access through your subscription, just use the Update Options button to get the latest updates. You should be using this version:
    https://support.microsoft.com/en-us/gp/office-2013-365-update
    15.0.4737.1003

    If you are using an MSI/boxed version of Access 2013, go here for the update:
    https://support.microsoft.com/en-us/kb/3054950


    Dirk Goldgar, MS Access MVP
    Access tips: www.datagnostics.com/tips.html

    • Marked as answer by w85 Thursday, July 16, 2015 11:16 PM
    Thursday, July 16, 2015 9:58 PM
  • I'm using 2.8 of 8.0 gb RAM. Using Windows 7 64bit. I have Internet Explorer and Outlook open. CPU usage 0-1% otherwise at the moment. I'm using Access 2013 32 bit.

    Switching between queries spikes my CPU usage up to 25%, for seemingly no good reason. I'm confused, because typically (after 45 seconds) the query will eventually load.

    Others seem to be having this problem too:

    http://answers.microsoft.com/en-us/office/forum/office_2010-access/design-view-freezes-in-access-2010/6e40461d-a0a6-4dd2-8d80-2e7778494e67?auth=1

    http://answers.microsoft.com/en-us/office/forum/office_2013_release-access/access-2013-crashes-every-time-i-try-to-switch/79db5e12-0667-4993-82c1-f1ff6a90e8c0

    http://www.access-programmers.co.uk/forums/showthread.php?t=261679

    Thursday, July 16, 2015 10:06 PM
  • Wow, how lucky am I that the fix was posted just two days ago!! Thanks goodness I wasn't using Access 2013 and experiencing this issue, well back in 2013! Thanks a ton for spotting this. Development work has been a nightmare before this fix.
    • Edited by w85 Thursday, July 16, 2015 11:21 PM
    Thursday, July 16, 2015 11:20 PM
  • So the fix worked?  It resolved the issue for you?


    Dirk Goldgar, MS Access MVP
    Access tips: www.datagnostics.com/tips.html

    Friday, July 17, 2015 1:32 AM
  • Yeah, the fix solved what was a really debilitating problem in Access. If I had just 2 queries open in design view, it took an average 1-2 minutes to toggle between them, or save changes to one. If I had anything more open, sometimes Access simply wouldn't unfreeze. And this was with files saved locally on my C:\ drive!

    Happy things are resolved now, but surprised it took Microsoft so long to issue a fix. Only in the past couple weeks did we upgrade to 2013, I'd been an early adopter this could have been a deal breaker for using Access.

    Sunday, July 19, 2015 2:51 PM
  • Re. the delay on a fix: it is likely that this problem effected a small subset of users. I've been using Access 2013 extensively for a couple of years and have never encountered the problem, for example. Could be something in your environment; a hardware or software interaction that wasn't obvious during development. But it's good that Microsoft has addressed it...
    • Edited by Gary Voth Sunday, July 19, 2015 3:53 PM
    Sunday, July 19, 2015 3:52 PM