How do I decompile a 2002 DB

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

My forms are taking a long time to open in design view and every thing I have
read this morning suggest that I should decopile. How would I accomplish
this in Access 2002. Thanks In Advance
 
Decompile a copy of the database by entering something
like this at the command prompt while Access is not
running. It is all one line, and include the quotes:

"c:\Program Files\Microsoft
Office\office\msaccess.exe" /decompile
"c:\MyPath\MyDatabase.mdb"
 
oh yeah...forgot to mendtion. Compact again.
-----Original Message-----
Decompile a copy of the database by entering something
like this at the command prompt while Access is not
running. It is all one line, and include the quotes:

"c:\Program Files\Microsoft
Office\office\msaccess.exe" /decompile
"c:\MyPath\MyDatabase.mdb"


.
Click to expand...
 
This did not work as I failed to mention that I have security on this DB and
I guess I didn't think to mention it because I thought the DB would already
be open. Is there a work around for this?
 
hi again,
I got that bit of info from allen brown a while back. it
did help me. but i'm not sure where to go from here.
sorry for the bum steer.
 
Hi
It wasn't a bum steer I failed to mention it was secure. Do you think I
should ask someone in the security section?
 
No, you can just ask me.
:-)

A quick syntax test reveals this will work to decompile a secured database.
1. Make a backup copy of the database please!
2. I would have no databases or Access opened for this test.
3. Use the following syntax:

"C:\Program Files\Microsoft Office\Office\MSACCESS.EXE" /User"YourUserNameHere"
/Pwd"YourPasswordHere" /decompile "<Full Path to File Here>" /wrkgrp "<Full Path To Workgroup File
Here>"

There will most likely be some major line wrapping there. Double check the location of your
Msaccess.exe file. It could be in a different location than the olne specified. Watch for spaces in
there as well. All of this should be one line in the Run box. Also, make sure the UserName/Password
is the "SuperUser" of the database or someone who is a member of the Admins group.

4. Then compact your database to clear out the hidden compiled version of your code.
5. You may then want to import all the objects into a new database container.
 
Back
Top