Damaged DB

Article View: comp.databases.ms-access

Article #251

Back to comp.databases.ms-access Previous Next

#251

From: Erik Vestergaard
Date: Tue, 01 Dec 1998 00:00

29 lines
1930 bytes

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: <01be1d18$013147a0$80200b0a@lecervv>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 1041a7,2011579230da4dd4,start
X-Google-Attributes: gid1041a7,public
X-Google-Thread: 11250c,2011579230da4dd4,start
X-Google-Attributes: gid11250c,public
X-Google-Thread: f8db2,2011579230da4dd4,start
X-Google-Attributes: gidf8db2,public
X-Google-Thread: fa6f6,2011579230da4dd4,start
X-Google-Attributes: gidfa6f6,public
X-Google-Thread: ff0ac,2011579230da4dd4,start
X-Google-Attributes: gidff0ac,public
From: "Erik Vestergaard" <lecerv@lec.dk>
Subject: Damaged DB
Date: 1998/12/01
Message-ID: <01be1d18$013147a0$80200b0a@lecervv>
X-Deja-AN: 417430571
X-Complaints-To: abuse@uni2.dk
X-Trace: news.get2net.dk 912509310 193.162.192.11 (Tue, 01 Dec 1998 11:48:30 MET DST)
Organization: UNI2 Internet Kunde
NNTP-Posting-Date: Tue, 01 Dec 1998 11:48:30 MET DST
Newsgroups: comp.databases.ms-access,dk.edb.programmering,it.comp.database.access,microsoft.public.access.tablesdbdesign,no.it.programmering.delphi