I picked up "Microsoft Office Access 2007 bible" and have been reading it for
the last few weeks and came across a piece of advice from this book on this
subject where they mention one possible way to fix corruption with a Form or
Report is to do the following:

Open the Form/Report in Design View
Open the properties for the Form/Report
Remove the Recordsource for the Form/Report By backspacing it all out
Save and Close the Form/Report
Open the Form/Report again
Replace the Recordsource information with whatever you just previously removed
Save and Close the Form/Report
Try running the Form/Report to see if its still corrupted or if you're
lucky, fixed.


"Vexen" wrote:

> I have been developing an application (Ziggy) for many years, and find that
> sometimes a Form gets 'corrupted': Attempting to open it causes Access to
> crash.
>
> Ziggy is only used by me (single user), and its size floats randomly between
> 6MB and 100MB, though the data in it only increases slowly. The "compact and
> repair" tool never fixes a corrupt form. I am using Windows Vista, and Office
> 2007 SP1.
>
> The solution is sometimes to copy all the items on the form to a new form, or,
> sometimes the solution is just to edit the form in Design mode and delete
> something, then put it back again. If the form can't be opened in Design mode,
> the solution is to import the form from a backup.
>
> Now, in this project,
>
> Whenever I open *any* form or table via buttons on the Ribbon, Access crashes.
> I can open them all fine in Design mode, and they operate normally and can
> invoke each other properly. But as soon as I open it normally, any attempt to
> open a form or table causes it to crash.
>
> Can anyone help?
>
> Q1. What causes these corruptions? I see online that they also occur in split
> databases (with front-end and back-end in different files), but as this is a
> single-user db, there is no point doing that.
>
> Q2. I knew how to recover individual forms from this, but how to I recover an
> entire application?
>
> Q3. Has anyone who experiences similar problems found any general ways around
> them?
>
> --
> --
> Vexen Crabtree
> http://www.vexen.co.uk/
>
>

Hi, thanks for sharing that tip.

Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia


"CrazyAccessProgrammer" <(E-Mail Removed)>
wrote in message news55FC460-2AD8-4090-84C5-(E-Mail Removed)...
>I picked up "Microsoft Office Access 2007 bible" and have been reading it
>for
> the last few weeks and came across a piece of advice from this book on
> this
> subject where they mention one possible way to fix corruption with a Form
> or
> Report is to do the following:
>
> Open the Form/Report in Design View
> Open the properties for the Form/Report
> Remove the Recordsource for the Form/Report By backspacing it all out
> Save and Close the Form/Report
> Open the Form/Report again
> Replace the Recordsource information with whatever you just previously
> removed
> Save and Close the Form/Report
> Try running the Form/Report to see if its still corrupted or if you're
> lucky, fixed.
>
>
> "Vexen" wrote:
>
>> I have been developing an application (Ziggy) for many years, and find
>> that
>> sometimes a Form gets 'corrupted': Attempting to open it causes Access to
>> crash.
>>
>> Ziggy is only used by me (single user), and its size floats randomly
>> between
>> 6MB and 100MB, though the data in it only increases slowly. The "compact
>> and
>> repair" tool never fixes a corrupt form. I am using Windows Vista, and
>> Office
>> 2007 SP1.
>>
>> The solution is sometimes to copy all the items on the form to a new
>> form, or,
>> sometimes the solution is just to edit the form in Design mode and delete
>> something, then put it back again. If the form can't be opened in Design
>> mode,
>> the solution is to import the form from a backup.
>>
>> Now, in this project,
>>
>> Whenever I open *any* form or table via buttons on the Ribbon, Access
>> crashes.
>> I can open them all fine in Design mode, and they operate normally and
>> can
>> invoke each other properly. But as soon as I open it normally, any
>> attempt to
>> open a form or table causes it to crash.
>>
>> Can anyone help?
>>
>> Q1. What causes these corruptions? I see online that they also occur in
>> split
>> databases (with front-end and back-end in different files), but as this
>> is a
>> single-user db, there is no point doing that.
>>
>> Q2. I knew how to recover individual forms from this, but how to I
>> recover an
>> entire application?
>>
>> Q3. Has anyone who experiences similar problems found any general ways
>> around
>> them?
>>
>> --
>> --
>> Vexen Crabtree
>> http://www.vexen.co.uk/
>>
>>

[blah]

access 2007 is a complete nightmare, microsoft's best days are way behind it...oh, too bad, we're all stuck with this POS.