PC Review


Reply
Thread Tools Rate Thread

Corrupt split database

 
 
=?Utf-8?B?Q29ubmll?=
Guest
Posts: n/a
 
      27th Jun 2006
We have a split database and the back end is corrupt. Access 2002. Front
end is about 88 meg, back end 24 meg. We suspect that the db was closed
improperly and thus caused the corruption. We have attempted all of the
normal fixes. Are there any non-traditional methods of restoring a db, short
of buying a third party utility.

Any help appreciated,
Connie
 
Reply With Quote
 
 
 
 
Arvin Meyer [MVP]
Guest
Posts: n/a
 
      27th Jun 2006
First, always work on a copy of the database. Working on the original may
make it impossible for a repair service to fix it.

Download a copy of JetComp.exe:

http://support.microsoft.com/default...b;EN-US;273956

Also have a look at the Microsoft KB article:

http://support.microsoft.com/default...b;EN-US;209137

Then have a look at Tony Toews' Access Corruption FAQ at:

http://www.granite.ab.ca/access/corruptmdbs.htm

for some suggestions. Unfortunately, some corruption cannot be fixed - you
may need to create a new database, import what can be salvaged, and recreate
the rest.

Although it's a paid service, Peter Miller does an outstanding job of saving
corrupt databases. Try this URL:

http://www.pksolutions.com
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

"Connie" <(E-Mail Removed)> wrote in message
news:E42EC3D1-38C0-41A2-BEF0-(E-Mail Removed)...
> We have a split database and the back end is corrupt. Access 2002. Front
> end is about 88 meg, back end 24 meg. We suspect that the db was closed
> improperly and thus caused the corruption. We have attempted all of the
> normal fixes. Are there any non-traditional methods of restoring a db,
> short
> of buying a third party utility.
>
> Any help appreciated,
> Connie



 
Reply With Quote
 
=?Utf-8?B?Q29ubmll?=
Guest
Posts: n/a
 
      27th Jun 2006
Hi Alvin
Thank you so much. We are checking out the links now.
Connie



"Arvin Meyer [MVP]" wrote:

> First, always work on a copy of the database. Working on the original may
> make it impossible for a repair service to fix it.
>
> Download a copy of JetComp.exe:
>
> http://support.microsoft.com/default...b;EN-US;273956
>
> Also have a look at the Microsoft KB article:
>
> http://support.microsoft.com/default...b;EN-US;209137
>
> Then have a look at Tony Toews' Access Corruption FAQ at:
>
> http://www.granite.ab.ca/access/corruptmdbs.htm
>
> for some suggestions. Unfortunately, some corruption cannot be fixed - you
> may need to create a new database, import what can be salvaged, and recreate
> the rest.
>
> Although it's a paid service, Peter Miller does an outstanding job of saving
> corrupt databases. Try this URL:
>
> http://www.pksolutions.com
> --
> Arvin Meyer, MCP, MVP
> Microsoft Access
> Free Access downloads:
> http://www.datastrat.com
> http://www.mvps.org/access
>
> "Connie" <(E-Mail Removed)> wrote in message
> news:E42EC3D1-38C0-41A2-BEF0-(E-Mail Removed)...
> > We have a split database and the back end is corrupt. Access 2002. Front
> > end is about 88 meg, back end 24 meg. We suspect that the db was closed
> > improperly and thus caused the corruption. We have attempted all of the
> > normal fixes. Are there any non-traditional methods of restoring a db,
> > short
> > of buying a third party utility.
> >
> > Any help appreciated,
> > Connie

>
>
>

 
Reply With Quote
 
Larry Linson
Guest
Posts: n/a
 
      27th Jun 2006
"Connie" <(E-Mail Removed)> wrote in message
news:AA73B846-CDFA-479F-AEB0-(E-Mail Removed)...
> Hi Alvin
> Thank you so much. We are checking out the links now.
> Connie


Do you have the information to bring the database up to date from the most
recent backup copy? If not, there's a lesson to be learned from that, too.

Larry Linson
Microsoft Access MVP


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Cannnot split the database usling Database splitter wizard Frank Situmorang Microsoft Access VBA Modules 2 21st Mar 2008 08:37 AM
How can I split database results with ExecuteReader and Split? needin4mation@gmail.com Microsoft ASP .NET 2 5th May 2006 11:36 PM
Question re: locks in split database - form level and database lev =?Utf-8?B?QW1pdA==?= Microsoft Access Form Coding 0 11th Jul 2005 11:51 PM
change database from a split to not split =?Utf-8?B?Sm9lbA==?= Microsoft Access Database Table Design 2 14th Jul 2004 05:49 PM
Database Password does not work with Split Database Konrad Stoudenmire Microsoft Access Security 7 28th Jun 2004 10:24 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 11:44 PM.