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 7 2683
May be the 2002 ver is not supported by the system. You need to install
new version
Madhivanan
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
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
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
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
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
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 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
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...
|
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....
|
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...
|
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.
-----------------------...
|
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:
...
|
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...
|
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...
|
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...
|
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...
|
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...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 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 former...
|
by: ryjfgjl |
last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
| |