473,734 Members | 2,788 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Access Database Problem: "unrecogniz ed database format"

1 New Member
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
Jan 29 '08 #1
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
Jan 29 '08 #2
jyoung2
32 New Member
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
Jan 29 '08 #3
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
Jan 30 '08 #4
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.
Aug 19 '09 #5

Sign in to post your reply or Sign up for a free account.

Similar topics

1
6275
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)
3
6223
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):
7
26782
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...
11
3657
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!
5
2209
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!)
6
6305
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"
13
2424
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...
6
8996
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...
1
1994
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
0
8946
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
8776
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,...
1
9236
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
8186
agi2029
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...
0
6031
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
4550
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...
0
4809
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
3261
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
2
2724
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

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.