Article View: comp.databases.ms-access
Article #250Re: Damaged DB
From: Dev Ashish
Date: Thu, 03 Dec 1998 00:00
Date: Thu, 03 Dec 1998 00:00
51 lines
2636 bytes
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-mailReferences:
<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