Corruption errors in acc 2000 program

[ARC]

Hello all,

I'm trying to help a customer of mine recover data from an access 2000
program that appears to have corruption. Opening the file will open the
default / startup form, however, you can't get into the one module that is
present. They have the module named: Global Module. Double-clicking this
gives the error: "The module name 'Global Module' is misspelled or refers to
a module that doesn't exist."

I ran a repair, and this did not take care of the error.

I tried converting the program to access 2007, and it does convert without
error, but you still can't get into the module, nor can you rename the
module, or copy / paste it to a new mod. (copying/pasting gives the error:
Name conflicts with existing module, project, or object library).

Attempting to import the objects into a clean db gives a number of errors
(all 3 for each form imported):

* Name conflicts with existing module, project, or object library
* No Current Record
* The search key was not found in any record

Even though I can't import the forms into a clean db (gives the 3 errors
above for each form), I can open the forms and reports in both design mode
and view mode.

I went into the individual forms, and going into the event producedures, it
appears that all vba source code has been stripped from the program. Which
seems to point back to the 1st problem I mentioned of trying to get into the
Global Module.

Any ideas on this?

Many thanks,

Andy

[Tony Toews [MVP]]

"ARC" <PC*****@PCESoft.invalidwrote:

>I'm trying to help a customer of mine recover data from an access 2000
program that appears to have corruption.

Thanks for your detailed posting of the problem and your trouble shooting.

>Attempting to import the objects into a clean db gives a number of errors
(all 3 for each form imported):

* Name conflicts with existing module, project, or object library
* No Current Record
* The search key was not found in any record

Now this is very interesting. I've never read of such behavior before.

>I went into the individual forms, and going into the event producedures, it
appears that all vba source code has been stripped from the program. Which
seems to point back to the 1st problem I mentioned of trying to get into the
Global Module.

Corrupt Objects within a Corrupt Microsoft Access MDB
http://www.granite.ab.ca/access/corr...uptobjects.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.

Now what happens in A2000 and newer is that VBA code is stored as a huge blob in a
single record in a system table. It sure looks like that blob got corrupted. I
doubt anything will work for you other than possibly a commercial service such as PK
Solutions.

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/

[ARC]

Many thanks, Tony.

The customer is willing to pay for recovery, and I've probably put 1-2 hours
in already with no luck. I might have to refer them to PK Solutions.

I had not thought of looking in the MSys tables to see if there's
corruption, (even though I've been there a number of times) I had forgotten
that nice little trick.

Thanks again, Tony.

Andy
"Tony Toews [MVP]" <tt****@telusplanet.netwrote in message
news:tc********************************@4ax.com...

"ARC" <PC*****@PCESoft.invalidwrote:

>>I'm trying to help a customer of mine recover data from an access 2000
program that appears to have corruption.

Thanks for your detailed posting of the problem and your trouble shooting.

>>Attempting to import the objects into a clean db gives a number of errors
(all 3 for each form imported):

* Name conflicts with existing module, project, or object library
* No Current Record
* The search key was not found in any record

Now this is very interesting. I've never read of such behavior before.

>>I went into the individual forms, and going into the event producedures,
it
appears that all vba source code has been stripped from the program. Which
seems to point back to the 1st problem I mentioned of trying to get into
the
Global Module.

Corrupt Objects within a Corrupt Microsoft Access MDB
http://www.granite.ab.ca/access/corr...uptobjects.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.

Now what happens in A2000 and newer is that VBA code is stored as a huge
blob in a
single record in a system table. It sure looks like that blob got
corrupted. I
doubt anything will work for you other than possibly a commercial service
such as PK
Solutions.

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/

[Alan]

On Jun 12, 3:01*am, "ARC" <[e-mail]:

Many thanks, Tony.

The customer is willing to pay for recovery, and I've probably put 1-2 hours
in already with no luck. I might have to refer them to PK Solutions.

I had not thought of looking in the MSys tables to see if there's
corruption, (even though I've been there a number of times) I had forgotten
that nice little trick.

Thanks again, Tony.

Andy
"Tony Toews [MVP]" <[e-mail] in messagenews:tc********************************@4ax .com...

"ARC" <[e-mail]:

>I'm trying to help a customer of mine recover data from an access 2000
program that appears to have corruption.

Thanks for your detailed posting of the problem and your trouble shooting.

>Attempting to import the objects into a clean db gives a number of errors
(all 3 for each form imported):

>* Name conflicts with existing module, project, or object library
* No Current Record
* The search key was not found in any record

Now this is very interesting. *I've never read of such behavior before.

>I went into the individual forms, and going into the event producedures,
it
appears that all vba source code has been stripped from the program. Which
seems to point back to the 1st problem I mentioned of trying to get into
the
Global Module.

CorruptObjects within aCorruptMicrosoft AccessMDB
http://www.granite.ab.ca/access/corr...uptobjects.htm

The little documented SaveAsText and LoadFromText may help if an objectis
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 newMDB.
Application.LoadFromText acForm,"MyForm","c:\from.txt"

Sample code athttp://www.datastrat.com/Code/DocDatabase.txtfor saving
all objects
in anMDB.

Now what happens in A2000 and newer is that VBA code is stored as a huge
blob in a
single record in a system table. *It sure looks like that blob got
corrupted. * I
doubt anything will work for you other than possibly a commercial service
such as PK
Solutions.

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/- Hidequoted text -

- Show quoted text -

You can create a new, empty database. Go to File menu-Get External
Data-Import. Now you can import every valid table. This will give
you a clean set of systems tables; If this doesn't work, you may try
some software. You can try a utility called Advanced Access Repair to
repair your Access MDB file. It works rather well for my corrupt
Access MDB files. Its web address is http://www.datanumen.com/aar/
Hope this helps.

[Tony Toews [MVP]]

Alan <fy*@datanumen.netwrote:

>; If this doesn't work, you may try
some software. You can try a utility called Advanced Access Repair to
repair your Access MDB file. It works rather well for my corrupt
Access MDB files. Its web address is <snipp>
Hope this helps.

You also work for that company. Posting without disclosing any
connection is highly unethical and sleazy.

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/