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

[@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 :(

[@Jojosmith342]

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

[@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

[@greentrurtle4451]

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

[@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. :)

[@abdoulayetoure9965]

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

[@599CD]

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