Janet Erbach
jerbach.access at gmail.com
Wed May 30 09:09:51 CDT 2007
Hey everybody - I ended up re-installing, but it wasn't to painful - because the install exe file actually had a 'repair' option!! So the corruption has been taken care of, and I've re-imported all my custom stuff. And from now on I faithfully swear to make backups on a daily basis. Honest. Janet On 5/30/07, Janet Erbach <jerbach.access at gmail.com> wrote: > > Susan - Thanks for clarifying the Excel method for me. I'll try that one > more time. > > And hello, Rocky - I did try decompile, about TWENTY times. No luck. > > And Arthur - since this particular *!$% application has more underwear to > get bundled up in than Windows itself, importing all the 'clean' items into > an empty database didn't really work either. I've got good backup copies of > each form report, table, etc...but I can't actually run the app as a whole > because it isn't properly registered. > > Sooooooooo - if Susan's shot in the dark doesn't work, I'm going to > re-install the app from scratch and then import all my custom work from the > 'fill the empty database' backup I've got. > > Thanks everyone - I'm glad to be in on this forum. Steven's been > pestering me about it for a long time, and I finally got schmart and paid > attention! > > Janet Erbach > > > > On 5/29/07, Rocky Smolin at Beach Access Software <rockysmolin at bchacc.com> > wrote: > > > > Late to the party here but have you tried decompile? > > > > Rocky > > > > > > > > > > > > > > > > > > -----Original Message----- > > From: accessd-bounces at databaseadvisors.com > > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Janet Erbach > > Sent: Tuesday, May 29, 2007 12:13 PM > > To: Access Developers discussion and problem solving > > Subject: Re: [AccessD] How to repair corrupt database > > > > Susan - > > > > When you say 'open in Excel' do you mean just grab one table out of the > > 50+ > > that are in there? If so...I tried it, and no luck. I already tried > > deleting the code attached to ReportX - and I can delete it, but then I > > get > > a 'save failed' error. Let me know if I misinterpreted your Excel > > method. > > > > Thanks! > > > > Janet > > > > > > On 5/29/07, Susan Harkins <ssharkins at setel.com> wrote: > > > > > > This is going to sound really odd, but I have seen it work. Open it in > > > > > Excel > > > -- DO NOT save your mdb file as a Excel worksheet -- you'll totally > > > destroy it. Just open it. Then, close it. I have absolutely no idea > > > why it sometimes works, I just not that it does. Word of warning, it > > > probably won't work, and you might want to make a copy before you do > > > this. I've never seen opening an mdb in Excel hurt anything -- only if > > > you save it as an xls file -- but I'd be over-cautious. > > > > > > You mentioned that in the new database, where you imported all the > > > objects, that it's still complaining about missing variables, etc. > > > Does ReportX's module have any code in it? Since you can't delete the > > > module, try erasing all the code, then repair. Just a thought. > > > > > > Susan H. > > > > > > 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 > > > -- > > > AccessD mailing list > > > AccessD at databaseadvisors.com > > > http://databaseadvisors.com/mailman/listinfo/accessd > > > Website: http://www.databaseadvisors.com > > > > > > Internal Virus Database is out-of-date. > > > Checked by AVG Free Edition. > > > Version: 7.5.467 / Virus Database: 269.7.0/804 - Release Date: > > > 5/14/2007 > > > 4:46 PM > > > > > > > > > -- > > > AccessD mailing list > > > AccessD at databaseadvisors.com > > > http://databaseadvisors.com/mailman/listinfo/accessd > > > Website: http://www.databaseadvisors.com > > > > > -- > > AccessD mailing list > > AccessD at databaseadvisors.com > > http://databaseadvisors.com/mailman/listinfo/accessd > > Website: http://www.databaseadvisors.com > > > > No virus found in this incoming message. > > Checked by AVG Free Edition. > > Version: 7.5.472 / Virus Database: 269.8.1/822 - Release Date: 5/28/2007 > > > > 11:40 AM > > > > > > -- > > AccessD mailing list > > AccessD at databaseadvisors.com > > http://databaseadvisors.com/mailman/listinfo/accessd > > Website: http://www.databaseadvisors.com > > > >