Corrupt Database

[Steve]

Hi

Can anyone help with the following:

I try open an Access 2002 Database, I get a message that the database needs
to be repaired as it was not closed properly, I select the option to repair
the database I am then given the error:

Run-time error 3343
Unrecognized database format.

I know the file is an Access DB. Is there a tool available to repair the
corrupt database. I have written code to compact and repair the database,
but I get the same result.

TIA
Steve

[Madhivanan]

May be the 2002 ver is not supported by the system. You need to install
new version

Madhivanan

[Steve]

I already have a full installation Of Access 2002 Loaded On The System

Steve

"Madhivanan" <ma************@gmail.com> wrote in message
news:11**********************@f14g2000cwb.googlegr oups.com...

May be the 2002 ver is not supported by the system. You need to install
new version

Madhivanan

[Tom van Stiphout]

On Fri, 18 Mar 2005 11:43:54 +0200, "Steve"
<st****@ufrmsa1.uniforum.org.za> wrote:

The easiest thing to do is to restore a backup.

Are you *really* sure this was a A2002 database? If not, try opening
it with a different version.

-Tom.

Hi

Can anyone help with the following:

I try open an Access 2002 Database, I get a message that the database needs
to be repaired as it was not closed properly, I select the option to repair
the database I am then given the error:

Run-time error 3343
Unrecognized database format.

I know the file is an Access DB. Is there a tool available to repair the
corrupt database. I have written code to compact and repair the database,
but I get the same result.

TIA
Steve

[Ed Robichaud]

Here's almost all there is to know about Access mdb corruption and possible
fixes:

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

-Ed

"Steve" <st****@ufrmsa1.uniforum.org.za> wrote in message
news:d1**********@ctb-nnrp2.saix.net...

Hi

Can anyone help with the following:

I try open an Access 2002 Database, I get a message that the database
needs
to be repaired as it was not closed properly, I select the option to
repair
the database I am then given the error:

Run-time error 3343
Unrecognized database format.

I know the file is an Access DB. Is there a tool available to repair the
corrupt database. I have written code to compact and repair the database,
but I get the same result.

TIA
Steve

[Elaine]

I don't know about 2002, but in previous versions this will be the
effect of someone opening the mdb with Word.

Can't repair from that cause, will need to restore from backup.

HTH,
Elaine

On Fri, 18 Mar 2005 14:22:05 GMT, "Ed Robichaud" <ed*********@wdn.com>
wrote:

Here's almost all there is to know about Access mdb corruption and possible
fixes:

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

-Ed

"Steve" <st****@ufrmsa1.uniforum.org.za> wrote in message
news:d1**********@ctb-nnrp2.saix.net...

Hi

Can anyone help with the following:

I try open an Access 2002 Database, I get a message that the database
needs
to be repaired as it was not closed properly, I select the option to
repair
the database I am then given the error:

Run-time error 3343
Unrecognized database format.

I know the file is an Access DB. Is there a tool available to repair the
corrupt database. I have written code to compact and repair the database,
but I get the same result.

TIA
Steve

[Tony Toews]

Elaine <no******************@commerce.state.ak.us> wrote:

I don't know about 2002, but in previous versions this will be the
effect of someone opening the mdb with Word.
Correct, but there are also many other causes of corruption.
Can't repair from that cause, will need to restore from backup.

If opened from Word yes, you are correct. If other causes there is still hope.

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

[Elaine]

Tony,

I *know* there are other causes. BUT with the error described the
simples explanation is probably that someone attempted to open this
with Word, especially since people continue to install the stupid
"Open Office Document" shortcuts.

"Unrecognized database format" points so hard at opening with Word it
is best to start there first.

I have only rarely had corrupted Access databases and the Word problem
is the *only* way this particular error has arisen.

Elaine

On Sun, 20 Mar 2005 02:42:16 GMT, Tony Toews <tt****@telusplanet.net>
wrote:

Elaine <no******************@commerce.state.ak.us> wrote:

I don't know about 2002, but in previous versions this will be the
effect of someone opening the mdb with Word.

Correct, but there are also many other causes of corruption.

Can't repair from that cause, will need to restore from backup.

If opened from Word yes, you are correct. If other causes there is still hope.

Tony