One of my important access 2002 files just got corrupted the other day. The
option to repair it dont seem to take in the file at all and keeps repeating
the same message on how to attempt a repair on it by backing it up etc.


I searched the web, found several free but pay - type programs , but $299 is
a bit steep for one file repair. Found another site in the UK who said to
email it to them zipped up and would quote a repair. It came to $22 USD, so
I tried it. Its now in 2000 format , looks different and alot of the
important fields are gone. I did find a bu of this file, but its from back
in JAN. The basic structure of fields and forms is the same, only there are
new records and some of their fields are bigger numbers in the more recent
copy that was corrupted. Is there some way to utilize these 2 files and get
one up to date new file?

default wrote:
> One of my important access 2002 files just got corrupted the other day. The
> option to repair it dont seem to take in the file at all and keeps repeating
> the same message on how to attempt a repair on it by backing it up etc.
>
>
> I searched the web, found several free but pay - type programs , but $299 is
> a bit steep for one file repair. Found another site in the UK who said to
> email it to them zipped up and would quote a repair. It came to $22 USD, so
> I tried it. Its now in 2000 format , looks different and alot of the
> important fields are gone. I did find a bu of this file, but its from back
> in JAN. The basic structure of fields and forms is the same, only there are
> new records and some of their fields are bigger numbers in the more recent
> copy that was corrupted. Is there some way to utilize these 2 files and get
> one up to date new file?
>
>
>

Sorry to sound gloomy, but if what you have to rebuild with are:
- an old bu lacking records with outdated data types, and
- a recovered file lacking "important" fields,

how do you expect to get an up-to-date file?

--
Smartin

Smartin,
You have not said as to the nature of your problem. I also take it that this
is not a valuable file, else you would have it backed up both as a file and
also on paper as to both the file structure and also the data that it holds
(held). If your problem is with just a table and you know the table
structure, then can be rebuilt, ditto for a query. If you have lost a form,
well just build another, they can be assembled in rough form by the wizards
that are available. The people who repaired it should know a bit about.
The bottom line is what have you in place to assist a rebuild.
Dave


"Smartin" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> default wrote:
>> One of my important access 2002 files just got corrupted the other day.
>> The option to repair it dont seem to take in the file at all and keeps
>> repeating the same message on how to attempt a repair on it by backing it
>> up etc.
>>
>>
>> I searched the web, found several free but pay - type programs , but $299
>> is a bit steep for one file repair. Found another site in the UK who said
>> to email it to them zipped up and would quote a repair. It came to $22
>> USD, so I tried it. Its now in 2000 format , looks different and alot of
>> the important fields are gone. I did find a bu of this file, but its from
>> back in JAN. The basic structure of fields and forms is the same, only
>> there are new records and some of their fields are bigger numbers in the
>> more recent copy that was corrupted. Is there some way to utilize these 2
>> files and get one up to date new file?
>>
>>
>>
>
> Sorry to sound gloomy, but if what you have to rebuild with are:
> - an old bu lacking records with outdated data types, and
> - a recovered file lacking "important" fields,
>
> how do you expect to get an up-to-date file?
>
> --
> Smartin

Ill try to clear up the misinterpretation, or my lack of comprehensive
knowledge of access.

The file is an important file, the last bu is dated JAN 06. The corrupted
file was updated many times past that point, but only with numeric fields
increasing or decreasing in value in exsisting fields, and new records
inserted into the exsisting file structure. these are the only 2 differences
between the bu and the current....except of course the corruption. My
question, is that if I can compare what records are new records, and are
able to be inserted into the old BU - and essentialy overwrite the old
records with the non corrupted new records, we will be alot closer to what
the current file was before it was corrupted.

If I was able to know what records or fields are corrupted or unreadable in
the bad file, I could resurrect at least some of the info I need. the
concept of having the bu file means I have a working access file that can
accept and be updated with new records or changes to fields etc. If the
recent corrupted file has the structure in disarray, and good records, then
we can use both these files to the goal. Does that make sense?

"default" <(E-Mail Removed)> wrote:

>One of my important access 2002 files just got corrupted the other day. The
>option to repair it dont seem to take in the file at all and keeps repeating
>the same message on how to attempt a repair on it by backing it up etc.

There are other things you can try such as attempting to import the
MDB into a new MDB.

For more information on corruption including possible causes,
determining the offending PC, retrieving your data, links, official MS
KB articles and a list of vendors who state they can fix corruption
see the Microsoft Access Corruption FAQ at
http://www.granite.ab.ca/access/corruptmdbs.htm

>I searched the web, found several free but pay - type programs , but $299 is
>a bit steep for one file repair. Found another site in the UK who said to
>email it to them zipped up and would quote a repair. It came to $22 USD, so
>I tried it. Its now in 2000 format , looks different and alot of the
>important fields are gone.

Sure sounds like they didn't do a good job.

> I did find a bu of this file, but its from back
>in JAN. The basic structure of fields and forms is the same, only there are
>new records and some of their fields are bigger numbers in the more recent
>copy that was corrupted. Is there some way to utilize these 2 files and get
>one up to date new file?

See the following page for a list of utilities to compare Access
databases
http://www.granite.ab.ca/access/thirdparty.htm

But I don't know that this will help much given that you're dealing
with a "repaired" database which isn't repaired all that well.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

Hi default and Tony,

When I have encountered a corrupted Access database or corrupt objects
within it that JETCOMP.EXE -- -- see
http://support.microsoft.com/kb/273956 -- could not fix, I was able to
totally retrieve all information, by importing all the objects from the
damaged DB into a new one, using the code given in the KB article at:

http://support.microsoft.com/default...&Product=acc97
for Access 97

http://support.microsoft.com/kb/298174/ for Access 2000/2002/2003

Alan


"Tony Toews" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> "default" <(E-Mail Removed)> wrote:
>
>>One of my important access 2002 files just got corrupted the other day.
>>The
>>option to repair it dont seem to take in the file at all and keeps
>>repeating
>>the same message on how to attempt a repair on it by backing it up etc.
>
> There are other things you can try such as attempting to import the
> MDB into a new MDB.
>
> For more information on corruption including possible causes,
> determining the offending PC, retrieving your data, links, official MS
> KB articles and a list of vendors who state they can fix corruption
> see the Microsoft Access Corruption FAQ at
> http://www.granite.ab.ca/access/corruptmdbs.htm
>
>>I searched the web, found several free but pay - type programs , but $299
>>is
>>a bit steep for one file repair. Found another site in the UK who said to
>>email it to them zipped up and would quote a repair. It came to $22 USD,
>>so
>>I tried it. Its now in 2000 format , looks different and alot of the
>>important fields are gone.
>
> Sure sounds like they didn't do a good job.
>
>> I did find a bu of this file, but its from back
>>in JAN. The basic structure of fields and forms is the same, only there
>>are
>>new records and some of their fields are bigger numbers in the more recent
>>copy that was corrupted. Is there some way to utilize these 2 files and
>>get
>>one up to date new file?
>
> See the following page for a list of utilities to compare Access
> databases
> http://www.granite.ab.ca/access/thirdparty.htm
>
> But I don't know that this will help much given that you're dealing
> with a "repaired" database which isn't repaired all that well.
>
> Tony
> --
> Tony Toews, Microsoft Access MVP
> Please respond only in the newsgroups so that others can
> read the entire thread of messages.
> Microsoft Access Links, Hints, Tips & Accounting Systems at
> http://www.granite.ab.ca/accsmstr.htm

Supertech wrote:
> The file is an important file, the last bu is dated JAN 06.

Let's be honest. Look at the calendar. Your last backup was close to a year
ago. *Important* files get backed up daily (except maybe weekends), so if
you don't have about 200 backups since then it means you didn't decide the
file was important until *after* you discovered it was corrupted. So it
wasn't important, and it's not valuable either if it's not worth $299 to
recover it.

You're hoping somebody will take pity on you and offer to recover this file
for you with their own recovery tool they bought. Unfortunately you're
asking the wrong crowd because the developers who answer questions in the
newsgroups religiously back up their work, so if files get corrupted and they
can't import into a new file or JetComp can't fix it, they restore from
backup. They don't need to buy recovery tools, so they can't use *theirs* to
recover your file.

That said, I'll take pity on you under two conditions:

1) You make a list of *all* your important files and start backing them up
daily or at least every day they're changed, and backup your computer either
weekly or monthly too so this never happens again, and
2) Your zipped file is small enough that I won't be sitting here till next
Tuesday waiting for it to download. I usually limit files to 5 MB, but my
inbox can handle files a little bigger.

If the recovery company only charged you $22 it's probably a very small file,
but I want to mention my other limitations too. I can only recover table
structures and data, so if you didn't split your database, that's another
lesson this disaster will teach you. I won't charge you anything; neither
will I guarantee I can recover anything because it sounds like you tried to
compact/repair the file yourself a few times and the recovery company
couldn't do much with what was left. For future reference, if Access warns
you that the file needs to be repaired, immediately stop what you're doing
and make a copy of the file, keep it in a safe place and never open it again.
Just make copies of it so if the new copy goes up in smoke you can start over
with another copy of the original.

> The corrupted
> file was updated many times past that point, but only with numeric fields
> increasing or decreasing in value in exsisting fields, and new records
> inserted into the exsisting file structure.

Let me see if I can translate that into English. You haven't changed the
table structures, but you updated some of the records that existed in Jan.
2006. You also added more records since the last backup. Please correct me
if I'm wrong, because "updated ... but only with numeric fields increasing or
decreasing in value in exsisting fields" translated into English might also
mean you *have* changed the table structures since the last backup by adding
new columns. These new columns are number data types and the tables aren't
normalized, so new column names take the format of Sales_2005, Sales_2006,
Sales_2007, etc.

> If I was able to know what records or fields are corrupted or unreadable in
> the bad file, I could resurrect at least some of the info I need.

That's what the recovery company was supposed to do for you, but if you gave
them the corrupted file *after* you compacted/repaired it yourself, there
might not be much to recover.

> If the
> recent corrupted file has the structure in disarray, and good records, then
> we can use both these files to the goal. Does that make sense?

Yes, but tools like that are at the *high* end, and if you aren't willing to
buy them you can't expect me to either. I'll see what I can do. I would
need the last backup and the corrupted file (I'm hoping it's from *before*
you repaired it). For comparison I'd like to see what the recovery company
recovered, but it's not required. What are the zipped sizes of these
separate files? You can compact a copy of the last backup, then zip it if
that helps reduce the size.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200611/1

"default" <(E-Mail Removed)> wrote in
news:(E-Mail Removed):

> I searched the web, found several free but pay - type programs ,
> but $299 is a bit steep for one file repair. Found another site in
> the UK who said to email it to them zipped up and would quote a
> repair. It came to $22 USD, so I tried it. Its now in 2000 format
> , looks different and alot of the important fields are gone.

PK Solutions is a legitimate Jet data recovery service. They don't
charge if they can't recover your data 100%. See pksolutions.com.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/

Hi,

You can try our product Advanced Access Repair to repair your Microsoft
Access databases. It is a powerful Access recovery tool that can
recover your corrupt databases. And it also support to repair all
versions of Microsoft Access databases.

Please visit http://www.datanumen.com/aar/index.htm for detailed
information about Advanced Access Repair.

And you can also download a free demo version at
http://www.datanumen.com/aar/aar.exe to see if our product can help
you.

Alan Chen
DataNumen, Inc. - World leader in data recovery technologies
Website: http://www.datanumen.com
Fax: +1-800-9917-FAX (US Toll-Free), +852-31829286 (HONG KONG)

Doesn't sound like much of a recovery company... if the file was highly
damaged you should expect them to tell you of the problems before you
paid. That said, they say you get what you pay for... $22 US sounds a
little cheap.

There are a few reputable recovery companies that are mentioned on here
frequently... out of interest, who did you use?

Tez

default wrote:
> One of my important access 2002 files just got corrupted the other day. The
> option to repair it dont seem to take in the file at all and keeps repeating
> the same message on how to attempt a repair on it by backing it up etc.
>
>
> I searched the web, found several free but pay - type programs , but $299 is
> a bit steep for one file repair. Found another site in the UK who said to
> email it to them zipped up and would quote a repair. It came to $22 USD, so
> I tried it. Its now in 2000 format , looks different and alot of the
> important fields are gone. I did find a bu of this file, but its from back
> in JAN. The basic structure of fields and forms is the same, only there are
> new records and some of their fields are bigger numbers in the more recent
> copy that was corrupted. Is there some way to utilize these 2 files and get
> one up to date new file?