[AccessD] How to repair corrupt database

Mrs. E.,

I looked through some older AccessD messages to find something
regarding exporting Access objects to text.  Here's a possibility:

http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='EATBloatV2.mdb'

Watch the wrap.  There are single quotes around the .mdb file name.

Mr. E.


On 5/29/07, Janet Erach <jerbach.access at gmail.com> wrote:
> We use a third-party database in Access 2003 in to manage our customer and
> sales data.   This morning I was importing a report from a "storage"
> database, and accidentally selected an extra report that I did not want.
> When I noticed this extra report – call it reportX -  was being imported, I
> hit 'cancel'.  And now my database is corrupt.
>
>  ReportX does NOT show up on the reports tab.  It does, however, show up in
> the modules project window, and I can even view the code attached to it;  I
> cannot delete it, though.  If I try to 'trick' the app by creating a dummy
> 'ReportX' I get the message that 'ReportX' already exists.
>
>  This is what I've tried so far:
>
>  1) Decompiled the app several times, then tried to recompile.  I get
> repeated errors that 'ReportX you entered in either the property sheet or
> macro is misspelled or refers to a report that doesn't exist.'  After 4 or
> five of those, I get 'Compile error: Module not found'.
>
>  2) Compact/repair the database – access crashes.
>
>  3) Running Jetcomp – error compacting database
>
>  4) Create an empty database – import everything.  Although the import still
> complains about missing 'ReportX', it seems like I'm able to successfully
> import everything else.  But I can't run the app because I get weird compile
> errors like 'variable not defined' or 'user defined type not defined'.  This
> app is so dang convoluted to begin with that I don't even know where to look
> for the basis of these errors.  It may even have to do with the fact that I
> have not properly registered this version of the app – the first time you
> run the installed app, it's supposed to detect your registration status and
> prompt you from there;  I don't know if there is a 'manual' registration
> option.
>
>  Is there anything else I can do to save the database?   ANYTHING??
>
>  Thanks –
>
> Janet Erbach