I am consulting on an urgent VBA project for a US entity (which I will
not name) connected to the current war. We have an Access MDE
Database that we are trying to decompile and are getting an error that
the VBA is corrupt. I tried to unsuccessfully to unlock the VBA for
the file with the VBA password unlocker program Advanced VBA Password
Recovery 1.41. The VBA version I'm running is DLL version: 6.3.91.8.
Should I try to install an earlier version of the VBA 6 dll? I keep
getting a message that the VBA is locked. I go under Tools and click
on the name of the VBA projects properties but it doesn't ask for a
password. I think the database was compiled on Access 2000. Any
suggestion. |
Clarification of Question by
socr2-ga
on
20 Mar 2003 05:07 PST
Well I tried a VB decompiler but received a message that the mde file
was no a 32 Bit program. Apparently there is a hidden VBA command:
Sub SaveAsText
(ObjectType As AcObjectType, ObjectName As String, FileName As String)
Member of Access.Application
which will write the VBA code to text files. They can than be
reimported from text with this hidden command:
Sub LoadFromText(ObjectType As AcObjectType, ObjectName As String,
FileName As String)
Member of Access.Application
I'm a total newbie when it comes to VBA. How would I write a VBA
script to export 20 forms and 20 reports to text at the same time,
correct the VBA, and import them back into the database?
Thanks
|
Request for Question Clarification by
serenata-ga
on
20 Mar 2003 05:39 PST
Hello Socr2 ~
Given the urgency and complexity of your problem, you may wish to
review Google's pricing suggestions and adjust the price on your
question.
The Google price suggestions are here -
http://answers.google.com/answers/help.html#howtospecify
Scroll down and look at "C. Price".
I would guess you'd have a better chance for getting an answer if you
do.
Yours,
Serenata
|
Request for Question Clarification by
hammer-ga
on
20 Mar 2003 07:39 PST
socr2,
There is no source code in an MDE. Making an MDE only stores the
compiled code, not the source. There may be a hacker tool out there
that can partially decompile the tokenized code, but it won't come out
in a form where you can made few changes and dump it back in. If you
don't have the original MDB, you are not going to be able to alter the
VBA.
- Hammer
|
Clarification of Question by
socr2-ga
on
20 Mar 2003 08:31 PST
Hi guys, thanks for your help. This is for the Armed Forces. I was
able to do something. The VBA modules are gone but I think I
recovered all the forms and reports which the client can use to build
a new database(I'm a neophyte offsite consultant who doesn't really
know what he's doing). The work was done by running AccessRecovery
against the MDE file. AccessRecovery does not natively restore MDE
files but I went to the “All Files” option instead of MDB files and
ran the program anyway, and it worked. AccessRecovery is available
here:
http://www.officerecovery.com/access/.
The two other recovery tools did not work as well. Easy Recovery File
Repair did recover some forms and three of the twenty reports, it has
worked wellfor me at other times with other kinds of Office files.
Its available here:
http://www.ontrack.com/easyrecoveryfilerepair/index.asp
AccessFix did not work at all this time. It is available here:
http://www.cimaware.com/accessfix.html.
They don't claim to recover Forms and Reports anyway. I believe their
ExcelFix is an excellent product which I have used with success in the
past. The client was most interested in the Forms and Reports. I
will continue to search for an appropriate VBA Decompiler to see if I
can recover some code from the modules.
In terms of price, I am just starting out and believe in the GNU
Software movement ideas and try to apply, in a way, the ideas to my
services. My fees are donation/nonprofit basis. I suggest a fee of
$20 per incident no matter how long it takes or how large or important
the file is. I have been working in my ignorance on this project for
12 hours straight and I apologize for being defensive here. I will
look at the pricing guidelines, but at this point cannot afford help
in more than a nominally above probono basis. I very much appreciate
the speed and level of experitise of the Google Answer Forum and
believe it is an excellent service for the net which despite its youth
may have few peers. Again I am new to seeking help through forums so
may not no where to get free speedy help in the best way.
Thank you again for yours and all the researchers and commenters help,
they are greatly appreciated by me and others who use this service,
and I apologize for any sharpness in my tone.
|
Request for Question Clarification by
hammer-ga
on
20 Mar 2003 08:50 PST
Socr2,
As you are a self-stated neophyte, you ,may not be aware that, by
decompiling this MDE, you may be hacking someone's code. One compiles
an MDB into an MDE for speed, but also in order to protect source
code. If you do not own the MDE, you may want to tread lightly.
- Hammer
|
Clarification of Question by
socr2-ga
on
20 Mar 2003 08:54 PST
Thanks for the warning. I'm assuming that since the client is from
the armed forces he has legitimate reasons for needing the code.
Perhaps I'm wrong. I will tread lightly.
|
Request for Question Clarification by
hammer-ga
on
21 Mar 2003 04:42 PST
Good luck with your project. By the way, since there does not really
appear to be an answer to your question, you may want to expire it.
- Hammer
|
