Desperate Need of Help Please with Forms and Reports not displayin

[Guest]

I built a very exhaustive database a few months ago and it has worked fine.
Today I went into it trying to pull reports and view some data in forms. I
was devasted to learn that none of my forms will display and most of my forms
won't due to 3 subforms that will not display. All of a sudden I cannot even
display design view on the 3 forms or design view on the many reports. What
can I do to resolve this issue? Unfortunately, I do not have a backup nor do
I remember the many details of how I built this database. I would appreciate
anyone's help.

thanks

 

[John Vinson]

I built a very exhaustive database a few months ago and it has worked fine.
Today I went into it trying to pull reports and view some data in forms. I
was devasted to learn that none of my forms will display and most of my forms
won't due to 3 subforms that will not display. All of a sudden I cannot even
display design view on the 3 forms or design view on the many reports. What
can I do to resolve this issue? Unfortunately, I do not have a backup nor do
I remember the many details of how I built this database. I would appreciate
anyone's help.

thanks

Well... MAKE A BACKUP. NOW. Do not pass GO, do not collect 200 lashes
with a wet noodle for not doing so before - make a backup NOW (you may
well need it later).

Then go to http://www.granite.ab.ca/access/corruptmdbs.htm and read
about how databases can become corrupt and (sometimes) get repaired.
You'll probably want to (*after* checking that your backup is no worse
than the original) open the database while holding the Shift key to
bypass any startup code, and use Tools... Database Utilities...
Compact and Repair. It may save your database (and it may do nothing,
and it might even destroy what's left - that's why the backup!!!).

If that fails see the various options in Tony's website above.

Good luck. Now go back up all your OTHER databases... <g>

John W. Vinson[MVP]