Recover Objects i.e. Forms, Reports, Module

[Tricia Young]

I have to recover the objects in my D/B. Everytime I open my mdb file it
just closes Access. I have been able to import the tables, queries, and all
but one Macro. I have made major design changes to the forms and reports.
The codes behind my forms and reports are major. I will never be able to
remember them all.

SOMEONE HAS TO HELP ME!

 

[Wayne Morgan]

If you are unable to recover them from a backup, then a recovery company may
be able to help. You will need to contact them and ask. You will find a few
of them listed at the bottom of this page, along with a few corruption
recovery suggestion that you may also want to try.

http://www.granite.ab.ca/access/corruptmdbs.htm

Make sure that you make a copy of your file and work on that in case the
recovery attempts make thing worse.

 

[Tricia Young]

Thanks, Wayne. I looked at the site below. How do I use the SavetoText and
LoadtoText feature?

Tricia

 

[Wayne Morgan]

You will find an example of using SaveAsText here:

http://www.datastrat.com/Code/DocDatabase.txt

For LoadFromText, if you don't have too many objects, it may be easiest to
just do so from the Debug window. If your objects have names that tell what
type of object they are, if you put each type of object in its own folder,
or changed the names of the text files to describe the type of object, you
could automate the LoadFromText.