Decompile 1

[debbieg]

There was a very helpful tip talking about decompiling a database. I have looked several places and can't come up with a decent explanation of what this is and what it does. Could someone explain this and how it is different from compile and compact.

Thanks,
Debbie

 

[RoyVidar]

Hi!

By your profile, I'm guessing this is an Access question, that might rather be posted in one of the Access fora.

That said, and assuming Access, here's a link on decompile:
Decompile or how to reduce Microsoft Access MDB/MDE size and decrease start-up times

Decompile and compact/repair in Access databases are two different things.

Compact repair cleans out temporary and deleted objects and records, reindexes, and performs some repairing.

Decompile does that what the name implies, decompile any compiled bits, so that you only have the "text code" left, which you then compile to make the app run faster. More info in the link...

Using decompile (at least on my setup) often resolves problems with code corruption (so that you don't have to import all objects into a new database - haven't done that since I became avare of the decompile;-))

Roy-Vidar

 

[LaurelLee]

I have a really silly problem I am encountering when trying to decomplie: my machine does not have an MSAccess.exe file anywhere on it! Why is that? I have all of the symptoms of an application that needs to be decompiled, but I cannot seem to get it to work. Any suggestions, RoyVidar? BTW, I am using AccessXP. Does decompile still exist in XP-land??

___________________________________________________________
With your thoughts you create the world--Shakyamuni Buddha

 

[RoyVidar]

Again - this is general database forum, this question might be better addressed in one of the Access fora.

Yes, decompile exists in XP land, I'm (mostly) using xp. And if you have Access installed, the msaccess.exe is bound to be somewhere;-)

On my xp setup, the msaccess.exe file resides in:

[tt]c:\program files\microsoft office\office10\[/tt]

But, I never specify the path, just:

[tt]msaccess /decompile c:\path\my.mdb[/tt]

Roy-Vidar