473,689 Members | 2,840 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Corrupt Database

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
Nov 13 '05 #1
7 2704

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

Madhivanan

Nov 13 '05 #2
I already have a full installation Of Access 2002 Loaded On The System

Steve

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

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

Madhivanan

Nov 13 '05 #3
On Fri, 18 Mar 2005 11:43:54 +0200, "Steve"
<st****@ufrmsa1 .uniforum.org.z a> 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


Nov 13 '05 #4
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.z a> 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

Nov 13 '05 #5
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*********@wd n.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.z a> 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


Nov 13 '05 #6
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
Nov 13 '05 #7
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.

"Unrecogniz ed 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****@teluspl anet.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


Nov 13 '05 #8

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
4300
by: NF | last post by:
Hey gang, I've been trying to restore a DB from it's MDF and LDF all morning; the catch? The LDF appears to be corrupt. When I first started the SQL Server, the db in question was marked as "Suspect'. I did some research on this and it has caused me to attempt detaching, backing up, deleting the LDF, using ATTACH DB and even sp_attach_single_file_db, and sp_add_data_file_recover_suspect_db.
4
2201
by: Big Time | last post by:
Major fiasco on my hands here. I was in the middle of updating a record when the system halted, and the Access DB became non responsive. Eventually I had to CTRL-ALT-DEL to close the application. When I tried to open the DB again, the file has become corrupt and I get the error message "The Microsoft Jet database engine cannot find the object "Databases". I understand a database can become corrupt during an interrupted write to a...
9
2479
by: Bungle | last post by:
Hi There, Does anybody know where i might be able to locate a tool/application that can determine whether a Database is corrupt?? Also, can a bad network connection cause a corruption to a database? Thanks in advance for any help, Bungle
4
1931
by: dixie | last post by:
I have come across some code to walk through the records of a corrupt table and copy it record by record to a new table. It comes from the MVPS.Org site and is as follows. ----------------------- (Q) How can I recover records from a corrupt table? (A) First, using Access while in the database window, copy the table's structure only from the corrupt table, if possible. Then using the code below, copy each individual row from the old...
4
2394
by: nepdae | last post by:
Well, after reading and hunting all over the web, including here, I still haven't been successful in my attempts to resolve my situation. So, I thought maybe I'd just ask. Here's the situation: I have an Access 2000 database (~15 users), split into a front- and back-end. Each user has a local copy of a workgroup file and the data file is out on a server. The problem started when the IS department upgraded the server at night, touching...
17
4885
by: shineofleo | last post by:
Here is the situation: I wrote a VB programm, which stores all the information in a single Access database file using jet engine. It worked well, however one of my customs reported that there was some problems with this programm. I checked, the log files showed that the database was corrupted. The customer told me that there no 'illegal' operation such as pull out the plug, or kill the programm via task manager... So is there any...
3
2205
by: rdemyan via AccessMonster.com | last post by:
One of my users had a corrupt front end that wouldn't open. My app is launched using a launching application (logon app). The logon app has a button for downloading a "fresh" copy of the front end from the server to the user's PC. I thought that this was a good idea since Access seems susceptible to corruption. I told the user to open the logon form and click the "Download" button, which would then replace the corrupt front end on his...
13
2670
by: Owen Jenkins | last post by:
Following on from an earlier post... I can reliably corrupt a record by doing the following ... Open two separate but identical front ends on one PC each linking to the same back end. Edit a records in one front end and leave it unsaved. Edit the same record in the other front end and save the change. Save the change in the first front end - this pops up the Write Conflict message to which I click Save.
1
2240
by: shayvillere | last post by:
I have a corrupt record that disappears after a compact, but reappears several days later. This is on a widely distributed Access 2003 application that is used by about 100 users. The database itself is only 70mb, but the problem this record causes is widespread. As soon as the record appears again, reporting gets thrown off in a major way, kicking out an "Invalid Argument" error when virtually any report is attempted. Any advice?
8
2773
by: iheartvba | last post by:
Hi this is a query made using access query builder: SELECT tblBank.BankID, Now() AS TimeRecd, Val(Right(nz(,0),3)) AS ConsID, "AutoCASH" AS RecUser, tblBank.Dt, Forms!frmRecCASHRunningBal!tbGroup AS GroupID FROM tblBank WHERE (((tblBank.Dt)>(!!-1) And (tblBank.Dt)<(!!+1))); 1.tblBank has a record in the Dt field which equals = 02/07/08 2. tbBankMinDate -1 = 01/07/08 3. tbBankRecDate + 1 = 03/07/08
0
8597
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9077
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
8949
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
8785
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
8793
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
1
6456
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5810
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4322
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
3
1952
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.