What "reference" libraries needed for Microsoft Access Professional Plus 2013

Those are the basic (minimum) references that are required by Access to operate, so I doubt that has anything to do with your issue.

I would start of by doing a decompile, and then I would create a new access database, and import all the objects into that. There are some issues that a Compact and Repair wont fix, but such a move MIGHT.

There are also certain things that make Access more likely to crash than others, such as external activeX references (of which you have none, unless they are late bound), not clearing object references (in my experience mostly an issue with class objects that reference forms or controls), and finally editing code while in break mode.

Anders has covered it well.

I might also after a /decompile create a fresh DB and import everything into it as you may have some general DB corruption.

Jim.

Which version of Access are you using?

Do you have any other versions of Access installed on this computer?

Does the same thing happen on other computers?

As noted by Anders, try a Decompile ... using the attached procedure.
aaQicPostDecompile.txt

Folk,
I have tried decompiling.  My database is an .accdb
Perhaps the decompile works but when I type the command nothing really appears and certainly no error message.
However, the database opens normally.
Has it decompiled? how do I know?

Open your DB, go to the VBE editor. Hit Debug->Compile. Assuming the code compiles without errors, the compile button will then be disabled.

Now open your db with the /decompile flag. Notice that going to VBE editor, the compile will now be enabled again. This is the indication that the decompile was succesfull.

You can find more info on decompile here:
How to do a decompile in Access

Thanks everyone , I have my decompile working now.  (Very neatly with the "SendTo" facility).

One final related question.

Is the following likely to cause corruption - I use these a lot.

1. While in "form view" I right click and go into "Design View" and then change the VBA.  Any reason not to do this?
2. Also, If my VBA crashes , I simply edit it on the spot and save and try again.  Any reason not to do this?

All contributions are much appreciated.

Hi Patrick
1) To some degree probably also depends on whether you have other forms/modules open and unsaved.
I find that generally there is a risk to live edits, but I find myself doing it anyway simply because the benefits outweigh the consequences (Provided you have good backups, and decompile once in a while)

FWIW, if you want a little background on /Decompile, see:

https://www.experts-exchange.com/articles/2043/Decompile-What-it-is-what-it-does-and-how-to-use-it.html

Jim.

>1.  Normally, there would be no issue. I do it ALL the time.
>2.  define 'crash'.  If it crashes, would't you have to close and reopen ?

Backup ... this is how SIMPLE it is to back up an ACCDB
1. Select  in Windows Explorer
2. Control C
3. Control V
INSTANT BACKUP ... with a name of 'Copy of YourDbName.accdb'
You can even do this when is it open, *assuming* everything is 'static' at the moment - no code is running (break point), no objects are open.

I also do "live" edits.  Be aware that sometimes they don't stick so save early, save often and test again.  I have automated code that creates two backups for me when I close a database I've been working on.  One backup goes to the server and one to a large external drive I use for on-site backups.  I also have backup code that actually exports all objects as text files.  I developed this because I had one database that constantly corrupted and I could never figure out the cause.  This text backup allowed me to rebuild the database in just a few minutes though if I found that I couldn't open the current copy (always said it wasn't a recognizable file type and it was dead).

THanks everyone,

(I note many familiar names that have helped me over the years).

At this point, I feel well armed to address corruption.

I am almost looking forward to my next bout of corruption!!

prone to crashing when I make changes to forms

Try to save your form as text and see if you find symptoms like mine.

https://www.experts-exchange.com/questions/28995420/Cant-open-Access-form.html?anchorAnswerId=41968870#a41968870

Thanks again Joe.