The VBA project in the database is corrupt

[small brother]

Dear All
I have an access 2003 database connected to sql server.
I have finished some modifications and used access workbench to compile it
as mde.
I have first decompiled it but it launched access 2007 instead of access 2003.

The database came corrupted and now i can not access any module, i get the
message : the module xxx is misspelled or refers to a module that doesn't
exist.
Same for the code from the forms and reports.

I tried to decompile it through the command line (run...) and compact and
repair..
but nothing.
I tried also through the jetcomp through the ODBC but always same problem.
I have a backup but i will loose 3 weeks of hard work.

Any help is welcome

Thanks and regards

 

[ggg]

No idea??

 

[Tony Toews [MVP]]

I tried to decompile it through the command line (run...) and compact and
repair..
but nothing.

Have you tried importing into a new MDB?

Corrupt Objects within a Corrupt Microsoft Access MDB
http://www.granite.ab.ca/access/corruption/corruptobjects.htm

The little documented SaveAsText and LoadFromText may help if an
object is corrupted or otherwise behaving weirdly.
At the debug/immediate window type:
Application.SaveAsText acForm,"MyForm","c:\form.txt
You can load the file into a new MDB.
Application.LoadFromText acForm,"MyForm","c:\from.txt"

Sample code at http://www.datastrat.com/Code/DocDatabase.txt for
saving all objects in an MDB.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/