Hey Michael, I have been down the gauntlet of M$Access corruption. So far I agree with the steps that Maureen has indicated, but you need to make sure you have the latest version of Access on your machine. I have seen older versions that could not fix a database while a newer version can.
I have a couple of the "fix it" programs but all they do is to recover the data, they DO NOT recover the schema, modules, forms etc. There are companies on the web the purport to do so, but it will cost you some $$$. IF you don't have the latest version of Access, and the mdb is relatively small, I can try to recover for you. HTH, Steve At 10:16 PM 9/8/2005, Maureen wrote: >Make sure the version of the ..mdb is not newer than the version of Access >you are trying to open it with. Acccess is not backward compatible. It >should tell you, and let you open it as read only but it doesn't alway. > >If you have the right version then: > >Step one: Delete the .ldb file with the same name as the .mdb - that is a >frequent source of problems. It's meaningless and will be recreated when the >..mdb needs it again. > >if that doesn't work. > >Step two: Make a copy of the .mdb file and run the database compression tool >against it from the database menu. > >if that doesn't work > >Step Three: Open an blank database and see if you can import the objects >from the import selection on the file menu. > >I'll look and see if I can find any recovery tools on the Microsoft site, >but I don't know of any. Let me know what versions you are working with. > > >phone at 478-994-5929 if you want to talk > > > >On 9/9/05, Michael Dinowitz <[EMAIL PROTECTED]> wrote: > > > > I'm sitting here with someone who has an access DB that cannot be > > opened.Any attempt to do so gives a "corruption detected" error message. > > Compressing and/or repairing it does not seem to work. The data is not the > > issue with it. What's really important is the forms and modules that the > > database contains. > > Does anyone know a way to extract these from an access DB? Is there an > > access deconstruction kit somewhere? > > > > Thanks > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:6:2387 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/6 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:6 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.6 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
