Janet Erach
jerbach.access at gmail.com
Tue May 29 13:04:07 CDT 2007
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