Hi, I need some help opening a corrupt Microsoft Access database file. I get an error message that says "unrecogniz ed database format". Since I can't open it, I can't export the data to another new database. I thought some of you gurus might have some help (yes, I have a backup but it was from a couple of months ago and I updated it since.)
Thanks
4 18029 sierra7 446
Recognized Expert Contributor
Hi,
The only time I have seen this message is when trying to open a recent version of a database (e.g. 2003) on a computer that last ran an older version of Access ('97), when both 2003 and '97 are installed.
If this might have been the case, you need to start Access 2000, or whatever, from the Start > Programs route, and then navigate to the database from the File > Open File menu options, rather than just clicking on the mdb file.
If it is not as simple as this, the next attack is to create a new empty database and try importing the objects (which Access seems to do without opening the donor database). From the File menu of the new database do File > Get External Data > Import, then navigate to you 'corrupt' database.
If you can't see the objects in the 'corrupt' database then I think you are into third party recovery tools, but the guys here may have some better suggestions.
Good luck
S7
did you decompile then try a compact and repair?
run the decompile from your run on the start menu. Make suere the path is correct
Then do the Compact and repair from the tools->database utilities
"C:\Program Files\Microsoft Office\Office11 \MSACCESS.EXE" /decompile
Hi, I need some help opening a corrupt Microsoft Access database file. I get an error message that says "unrecogniz ed database format". Since I can't open it, I can't export the data to another new database. I thought some of you gurus might have some help (yes, I have a backup but it was from a couple of months ago and I updated it since.)
Thanks
sierra7 446
Recognized Expert Contributor
did you decompile then try a compact and repair?
run the decompile from your run on the start menu. Make suere the path is correct
Then do the Compact and repair from the tools->database utilities
"C:\Program Files\Microsoft Office\Office11 \MSACCESS.EXE" /decompile
You will need to include a reference to the corrupt database file too . .
"C:\Program Files\Microsoft Office\Office11 \MSACCESS.EXE" "C:\Path\Corrup tDatabase.mdb" /decompile
S7
Megalog 378
Recognized Expert Contributor
Also, the "unrecogniz ed database format" error comes up when you're running a 2007 database that's been saved on a machine with 2007 SP1. Any database that has design changes with SP1, needs a SP1 client to run properly afterwards.
Sign in to post your reply or Sign up for a free account.
Similar topics |
by: Ixnay |
last post by:
Hello All,
I know this issue has be addressed a gazillion times in the past, but
none of the offered solutions seem to work for me.
I get this error when I attempt to pull down the RecordSource option
in my GUI. Does anyone have any ideas on how I can solve this?
I am running VB 6 with Service Pack 5 and Access 2000 (9.0.2720)
|
by: Noah |
last post by:
How does Image.putdata() work? I am using PIL 1.1.3.
This simple script throws an exception on putdata():
import Image
width = 10
height = 10
im = Image.new ("RGB", (width, height))
L = list(im.getdata())
k = 0
for y in range (height):
|
by: qbsu21th |
last post by:
Dear Sir/Madam,
I'm writing a small VB6.0 and Access 2002 application in XP OS. I selected the data control property RecordSource, I got the "Unrecognized database format 'xxx/xx/*.mdb' " error. when run the application and double selected the *.mdb database, I got the same error. Why?
I did converted the database file to access 2002. did i make any mistake when setup the reference or component?
can anyone give a help as soon as...
|
by: RWC |
last post by:
Hello,
I'm having trouble converting code in Access XP / 2002. I have some code
that declares an variable "as database" in Access 97, which is not
recognized in Access XP. I've tried to find a refrence to the items that
have changed between 97 and XP, and haven't been able to find anything yet.
I will continue looking, but if anyone can shed some light on this fairly
quickly, I would appreciate it.
Thanks In Advance!
|
by: Robin Tucker |
last post by:
My database has a column for numeric data items. How can I use
this number in the "format" command, such that for, say precision 2, I get
numbers like 2011.01 or 2387.00 and for 4 I would get 2011.0100 or
2387.0000?
(simple question I know!)
| |
by: sloan |
last post by:
I have a fairly simple RegEx code below.
I am given a file name, (which I don't control) , and need to change a
folder name in it.
The code below is choking on the filename not being escaped.
"Unrecognized escape sequence"
|
by: clarencemo |
last post by:
Hello,
I currently have a split db and I keep getting this error after about a day's worth of use. Once I've repaired it, I have created a clean db, imported the tables from a previous backup and everything works with no issues, until the next day when it gets corrupted again. I thought at first it was a bad form. so I rebuilt it.
Can u look at the code on this form?
What this form does is it inserts data from end-users (who have the...
|
by: MISASIA |
last post by:
I really hope someone can help me...
My office is using a Menu which running VB. There got many button in that Menu and one of the button which name as "GMR" hit error. Its prompt a message box "Run time error 3343 : Unrecognized database format \\sunsrv2\GMR\Database\GMR.mdb.". I check the path given and the file GMR.mdb is there. I not sure what is the problem since I don't have VB knowledge. It is a VB coding problem? But I didn't modify...
|
by: mitica grigore |
last post by:
hello
i use an access 2002-2003 database under an access 2007 environment and win xp sp3
i have about 24'000 records so far
sometimes, when i try to use "back-up database" or "compact & repair database" i obtain the "no current record" error and the process stops even if the progress bar showed some progress before the error occures.
give me please a solution.
thanks
|
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...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| |
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,...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
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();...
|
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...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |