🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: comp.databases.ms-access
Article #250

Re: Damaged DB

#250
From: Dev Ashish
Date: Thu, 03 Dec 1998 00:00
51 lines
2636 bytes
Hi Erik,

Install the two Access 95 patches.
http://support.microsoft.com/download/support/mslfiles/MSJTWNG.EXE
http://support.microsoft.com/download/support/mslfiles/VBA232A.EXE

Now, try importing all objects into a new database.  If this table fails for
some reason, try exporting it's contents to a text file or something.  If
all fails, contact www.pksolutions.com for any possible data recovery,
because (from what I've seen) you'd need to recreate the table from a
backup/scratch.

And oh, try and upgrade to Access 97.  Access 95 was way too buggy.

HTH
--
Dev Ashish (Just my $.001)
---------------
The Access Web ( http://home.att.net/~dashish )
---------------

Erik Vestergaard wrote in message <01be1d18$013147a0$80200b0a@lecervv>...
>Hi
>
>One of our end-users have sent in a ms-access DB, which is corrupted in som
>way.
>
>This is the facts:
>
>I've got a table whith a "BLOBfield" of type "LONGBINARY" in the
>database-script.
>In MS_Access 7.0 table design the datatype for the Field shows
>"OLE-Object".
>When I browse the records some of the record shows the text "Long Binary
>Data" in the field, and they are OK. But some of them shows "Ole-Object",
>and when I step into one of these fields with the cursor I get the
>following MS-Access ErrorDialog:
>
>"Data has changed Operation Stopped"
>
>When I try to select the records with SQL from a Delphiprogram or Database
>Explorer, I get no results, although the program does'nt die or catch
>exceptions.
>
>I'm a little confused about of the varying datatypetext, and would like to
>know what could be the reason  why the DB is fucked up.
>
>Could you send a copy of your answer to lecerv@lec.dk, thanks.
>
>Erik
>Denmark
Technical Details
Message-ID: <744mr6$obk@bgtnsc03.worldnet.att.net>
Path: arc1-ca.pugleaf.net!unknown!not-for-mail
References: <01be1d18$013147a0$80200b0a@lecervv>

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 1041a7,2011579230da4dd4
X-Google-Attributes: gid1041a7,public
X-Google-Thread: 11250c,2011579230da4dd4
X-Google-Attributes: gid11250c,public
X-Google-Thread: ff0ac,2011579230da4dd4
X-Google-Attributes: gidff0ac,public
X-Google-Thread: f8db2,2011579230da4dd4
X-Google-Attributes: gidf8db2,public
X-Google-Thread: fa6f6,2011579230da4dd4
X-Google-Attributes: gidfa6f6,public
From: "Dev Ashish" <dash10@hotmail.com>
Subject: Re: Damaged DB
Date: 1998/12/03
Message-ID: <744mr6$obk@bgtnsc03.worldnet.att.net>
X-Deja-AN: 418051022
References: <01be1d18$013147a0$80200b0a@lecervv>
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
Organization: AT&T WorldNet Services
Newsgroups: comp.databases.ms-access,dk.edb.programmering,it.comp.database.access,microsoft.public.access.tablesdbdesign,no.it.programmering.delphi