locked
Crashes in Access 2010 RRS feed

  • Question

  • I've been having persistent crashes using Access 2010, analysing some data. What I'd like to know is what I can do about it and if possible how I can prevent it.

    My OS is Windows XP. The project is relatively simple, with a lot of data (eg 1.5m records) in a couple of simple tables. I'm developing simple forms and queries, with some VBA. I used to be quite good inside Access 2010 but I'm fairly rusty, so I'm doing a few things that an adept wouldn't.

    Typically it works OK for a few hours, then I suddenly get a "Microsoft Access has encountered a problem and needs to close." message. This typically happens when I try to open the code window, or delete a form. At this stage I appear to have lost almost all of my work, because I can't repair it and I can't import from it (forms and modules particularly).

    This must be a relatively common problem - I'm not doing anything radical here - so if someone can point me to articles on how to fix or how to avoid, I'd be really, really appreciative.

    Andrew


    Andrew Gabb, Adelaide, South Australia

    Tuesday, March 22, 2016 12:29 PM

Answers

  • hi,

    have you testing a uncompilation/compact database ?

    the process is here :

    http://blogaccess.free.fr/?s=decomp

    Fabrice

    (my English is poor)


    Visitez mes sites : http://2gm.free.fr | http://loufab.developpez.com

    • Marked as answer by Gabby22 Wednesday, March 23, 2016 2:21 AM
    Tuesday, March 22, 2016 1:32 PM

All replies

  • hi,

    have you testing a uncompilation/compact database ?

    the process is here :

    http://blogaccess.free.fr/?s=decomp

    Fabrice

    (my English is poor)


    Visitez mes sites : http://2gm.free.fr | http://loufab.developpez.com

    • Marked as answer by Gabby22 Wednesday, March 23, 2016 2:21 AM
    Tuesday, March 22, 2016 1:32 PM
  • Thanks Fabrice, that worked even with my almost nonexistent French.

    I'd forgotton about the decompile - and I've rarely had it work successfully for me before.

    Andrew


    Andrew Gabb, Adelaide, South Australia

    Tuesday, March 22, 2016 9:24 PM