[AccessD] VBA project corruption

Andy Lacey andy at minstersystems.co.uk
Wed Jul 5 11:19:18 CDT 2006


Sounds like it tried and failed. Just to be sure make your command line just
the Access bit and the /decompile switch. Then select your MDB when the
selection screen pops up. That definitely invokes the decompile. But, as I
said, it sounds to me like it's already tried to decomp and that's not
worked.

What I've done in this circumstance is to selectively import components into
a fresh MDB, not trying to import all. That way I've found which component
is corrupt and then I've just concentrated on that, ie going back to an
earlier version and then making mods as necessary.

--
Andy Lacey
http://www.minstersystems.co.uk




--------- Original Message --------
From: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
To: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
Subject: Re: [AccessD] VBA project corruption
Date: 05/07/06 14:53


Andy,
I did try decompiling, using this syntax from a RUN window:
[path and file for MSAssess.exe] /decompile [path and file for my mdb].

Not sure if I constructed that correctly. But it appeared to chug along
and do something, but then ended up with the same VBA Corrupt message.

Steve

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Andy Lacey
Sent: Wednesday, July 05, 2006 9:31 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] VBA project corruption

Steve, have you tried decompiling?
--
Andy Lacey
http://www.minstersystems.co.uk


--------- Original Message --------
From: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
To: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
Subject: [AccessD] VBA project corruption
Date: 05/07/06 14:15


A nice, long productive holiday weekend working on my Access 2000 mdb...
Then yesterday I open the file and get "The Visual Basic for
Applications in this project is corrupt." Sigh.

I can shift bypass in to see objects. But completely unable to run
anything with code, nor can I even view code. Ran Repair and Compact to
no avail.

Normally in these situations, I start a new MDB, then import all objects
from the corrupt DB. But here, even the import function fails (same
error message) when I point it to the corrupt db.

I have heard of (but never used) third party utilities that work some
magic. Any advice? I'd love not to have lost many hours of work.

Thank you.

Steve Capistrant
Symphony Information Services
scapistrant at symphonyinfo.com
www.symphonyinfo.com
Office, Twin Cities: 763-391-7400, ext. 801.
Office, Toll free: 888-357-1373, ext. 801
Direct: 612-237-0075
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

________________________________________________
Message sent using UebiMiau 2.7.2




More information about the AccessD mailing list