How and Why You Should Compile Your Microsoft Access Database, and if Necessary, Decompile it!

If your Microsoft Access database is generating random errors that you can't explain or is crashing from time to time unexpectedly, you may want to try compiling your database. Likewise, if you are trying to create an encrypted front-end ACCDE file, and you get the "Microsoft Access was unable to create the .accde, .mde, or .ade file" error message, you may also want to compile your database. Compact and Repair doesn't fix the problem? Again, guess what... compile, and if necessary, decompile and recompile your database.
LEARN MORE:
599cd.com/Compile
LINKS:
Access Troubleshooter: 599cd.com/Trouble
Simple Security: 599cd.com/SimpleSecurity
Compact & Repair: 599cd.com/Compact
Philipp Stiefel's Article: 599cd.com/DecompileWhat
Mike Wolfe's Blog: NoLongerSet.com
COURSES:
FREE Access Beginner Level 1: 599cd.com/Free1
$1 Access Level 2: 599cd.com/1Dollar
ADDITIONAL RESOURCES:
Donate to my Tip Jar: 599cd.com/TipJar
Get on my Mailing List: 599cd.com/YTML
Contact Me: 599cd.com/Contact
TechHelp: 599cd.com/TechHelp
Consulting Help: 599cd.com/DevNet
Twitter: / learningaccess
en.wikipedia.org/wiki/Microso...
products.office.com/en-us/access
microsoft.com/en-us/microsoft...
KEYWORDS
access 2016, access 2019, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, #fasttips, compile, decompile, recompile, How do you compile an Access database, Decompile Your Microsoft Access Database, What does compiling an Access database do, How and Why to Decompile an Access Database, Microsoft Access was unable to create the .accde .mde or .ade file., compact, repair
QUESTIONS:
Please feel free to post your questions or comments below. Thanks.

[@Jojosmith342]

thanks again Richard for your valuable knowledge as always. thumbs up

[@novi90thebest]

Good morning Rick! Im writing from italy and im here to say THANKS! I learnt a lot from your videos about access and i would like to share with you something i realized with Access/Excel that is actually missing in your list!
I will be glad to share it with you and your experience!
Simone

[@599CD]

Feel free to share away...

[@novi90thebest]

@@599CD Oh :(

[@greentrurtle4451]

Dude, thank you!. Just had my first crash and this save my arse

[@599CD]

Welcome

[@abdoulayetoure9965]

Thank a lot for your details i have been helped a lot of thank again

[@599CD]

Welcome

[@stuartround]

You can just type /decompile after the path on the shortcut to your database - in the target field. Click OK or Apply, then when you click the shortcut the database will decompile when you open it. You have to remember to remove it afterwards.

[@599CD]

Thanks for the tip. That indeed sounds easier. :)

[@minhajabbasy9582]

Superb way of teaching and explaining. I really learned a lot and very much thankful to you. May the Lord bring happiness and prosperity in your life. Amen.

[@599CD]

Thanks and welcome

[@enargins]

I find it's helpful to just create a shortcut to MSAccess.exe with the /decompile switch and nothing else. Opening Access that way will cause it to decompile the next database that's opened. Thus, it's a one-size-fits-all solution. Once you have that shortcut, you don't have to get the path each time. You just double click on it to open Access, and then open your database to decompile it.

[@599CD]

Thanks for sharing

[@diegomarino25]

how can i do that?

[@MrIsla011]

Please when i insert a combo box - the combo box wizard doesn't appear ??!! can you told me how to fix this problem ?

[@599CD]

Turn your control wizards on.

[@robertodc62]

for compile the macros need to convert to vba first

[@599CD]

I believe so, yes.

[@thematrixteam5126]

I need to decompile.mde files