🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: microsoft.public.access
Article #8

Re: Please help -- urgent MDB recovery problem

#8
From: Alden Streeter
Date: Mon, 18 Jan 1999 00:00
41 lines
2378 bytes
There is a simple solution that does not require a hex editor:

Download the Jet engine 3.51 update from MS at:

http://support.microsoft.com/support/downloads/LNP126.asp?PR=ACC&FR=0&A=T&T=
B&M=S&

and use the JetComp utility.

Your problem was caused by a known bug in Jet 3.5 that is fixed by the
improved Compact process in Jet 3.51 that combines the Compact and Repair
processes.

Alden


Craig Spradling wrote in message ...
>One of my users today turned off his computer w/o closing the app (and
>therefore the mdb) -- the app was dormant at the time.  When I turned the
>computer back on I opened Access 97 to run a Repair and Compact, in that
>order, and a few seconds into the Repair method Windows 98 crashed with a
VX
>... error.  Since I couldn't recover from the crash, I rebooted and on the
>reboot it located two lost cluster chains, which I saved (only 4K).
>Whenever I try and load the mdb into Access I get the following error (and
>the file is not loaded):
>
>'C:\[Path\filename].mdb' isn't an index in table.  Look in the Indexes
>collection of the TableDef object to determine the valid index names.
>
>where [Path\filename] is just the description of the file.  Please someone
>tell me that I am not completely screwed.  I have a backup which is a
couple
>of days old but I really don't want to lose the interim data.  I would not
>think twice about paying someone to remedy the situation -- the file is
>small (1.6meg zipped) so I can easily email it.  Please let me know,
>
>Thanks,
>Craig
>
>
Technical Details
Message-ID: <#G$o8oyQ#GA.212@uppssnewspub04.moswest.msn.net>
Path: arc1-ca.pugleaf.net!unknown!not-for-mail
References: <XjBo2.4$Ul5.30@news.flash.net>

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ffff5,754c87d50ed36d94
X-Google-Attributes: gidffff5,public
X-Google-Thread: 10779a,754c87d50ed36d94
X-Google-Attributes: gid10779a,public
X-Google-Thread: 1131f0,754c87d50ed36d94
X-Google-Attributes: gid1131f0,public
X-Google-Thread: ff75c,754c87d50ed36d94
X-Google-Attributes: gidff75c,public
From: "Alden Streeter" <astreeter@email.msn.com>
Subject: Re: Please help -- urgent MDB recovery problem
Date: 1999/01/18
Message-ID: <#G$o8oyQ#GA.212@uppssnewspub04.moswest.msn.net>
X-Deja-AN: 434151867
References: <XjBo2.4$Ul5.30@news.flash.net>
Newsgroups: microsoft.public.access,microsoft.public.access.modulesdaovba,comp.lang.pascal.delphi.databases,borland.public.delphi.database.desktop
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3