[AccessD] VBA project corruption

Nope, moving to 2003 fixed it. 


Thanks,

Liz


 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte
Foust
Sent: Wednesday, July 05, 2006 6:16 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] VBA project corruption

Liz,

That's a long-standing problem with Access 2000 that was supposed to
have been fixed in SP2.  Are you saying you got it back in 2003?? 


Charlotte Foust

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Liz Doering
Sent: Wednesday, July 05, 2006 2:28 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] VBA project corruption

Andy, Bill, William and Dan,

Steve handed this issue off to me--being the boss has some
advantages--for him!  :)
 
Turns out, this is a .dll problem, not an actual object corruption
problem.  Microsoft explains it all here:
http://support.microsoft.com/?scid=kb;EN-US;304548. 
 
I didn't like the solutions they offered, which included exporting
objects to text files and reimporting them.  There are nearly 900 forms,
reports and modules in this .mdb!  Using the advice from
http://www.granite.ab.ca/access/decompile.htm, I made a .bat file to
decompile with 2003, ("C:\Program Files\Microsoft
Office\OFFICE11\MSAccess.exe" /decompile).  Once the decompile had run
(a long time), I saved the file to 2003 format and all was well.   

I imagine that this is because 2003 is playing nicely with version
6.3.91.8 of the Vbe6.dll file, unlike 2000.  But I don't understand why
just opening the thing in 2003 didn't have the same effect.  

Thanks for all your help!



Liz Doering
Symphony Information Services
ldoering at symphonyinfo.com
www.symphonyinfo.com
763-391-7400 x802

 


 

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

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


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com