Unrecognized Database Format - Repair File?
Jun 4, 2014
I created a database for my Dad's farm and it was all going well until I have been away for a while. I ensured the DB was backed up properly before I left but he didn't know how to back it up himself apparently so now we are in trouble.
Anyway, one day he went to open the DB and got the "unrecognized database format" message and the file doesn't open at all. The DB was created in Access 2013 and has only ever been used in 2013 (though my Dad uses runtime as he doesn't have a full license like me).
There is a couple of months worth of data which would cause a real headache if it was lost so fixing the file is the best outcome if at all possible, I tried the "compact and repair" from inside access without the DB opened but got the same message. I noticed that there is 3rd party software online claiming to fix all access files but they sound a little too good to be true and a good source of infecting my computer with a virus.
View Replies
ADVERTISEMENT
Sep 8, 2014
I have Microsoft Access DataBase file 2007. I tried to open it I got an error message "unrecognized file format".
The machines are DELL Windows 7 32bits with Microsoft office 2007.
While this file is worked with DELL Windows 7 64its.
Why I got this error and how to solve it?
View 5 Replies
View Related
Jun 17, 2005
Hello,
I had a database on a server. The serve went down. Now when I attempt to open the database I get the following error:
Unrecognized database format 'S:6277_Database_Tracking_Log6277_DatabaseScann ing_Database.mdb.
Is there anyway I can recovery this database? I do not have a backup. I tried to
Tools>Database Utilities>Compact and Repair Database
But that did not work.
Any suggestions?
Thanks.
View 3 Replies
View Related
Oct 6, 2005
Hello. Just got the following message when trying to open a database file: "Unrecognized database format '[filename]'.
Do anyone know why this occurs, and more important, do anyone know if it's possible to fix it?
View 11 Replies
View Related
Apr 23, 2006
Hi all...
can anybody pls pls help me?
some days back my backend database file was deleted.. and now anyhow i've recovered it thru one of the recovery software...
when i try to open the mdb file which is 3mb its giving me msg "Unrecognized database format"
i've done lot of excercises to open it.. but failed ..
pls i need help as this is a matter of my job
ali
View 1 Replies
View Related
Jul 24, 2015
I have my access database made using Access 2007.I have been working on this for about 6 months at work. I decide to make a copy of it to take home so I can work on it at home. At home I have Access 2013 and Access 2007. However when I try to open the copy I brought from work it gives me an error message saying "Unrecognized Database Format (File location and name..)"
View 6 Replies
View Related
Feb 4, 2014
One of our encoders experienced this error when trying to open the database (local). I tried to open it on my end and I could replicate the error she's getting. I have searched for possible solutions but to no avail. How to recover the corrupted database.
View 2 Replies
View Related
Jul 27, 2015
I am on a deadline today and when I went to open an Access 2007 (I abhor the fact that I am forced to use 2007) database, it will not open. It gives me the error message Unrecognized database format [file path].
I have tried creating a brand new database and importing all objects from old to new but I get the same error message.
View 14 Replies
View Related
Jun 9, 2014
I am getting the error " Unrecognized Database Format Error.
Sub ShowUserConnected()
Dim cn As New ADODB.Connection
Dim cn2 As New ADODB.Connection
Dim rs As New ADODB.Recordset
Dim i, j As Long
cn.Provider = "Microsoft.Jet.OLEDB.4.0"
[Code] ....
View 5 Replies
View Related
Aug 19, 2015
I have a standard shared Access DB application (i.e. central BE on the network, multiple users running their own copy of the FE on their local machine) Has been in production for a while, no major issues.
New user has been added in recent weeks. My error logger has picked up an error he hit earlier today - doesn't appear to have been fatal (he hasn't come to me with a problem, suggesting he just "OK"d the error prompt and continued on - I need to confirm this with him though...)
Error was 3343 "Unrecognized database format 'C:TempMyDBMyDB.accde'."
Can see it was tripped on a particular form which queries certain data into a subform (so he was obviously able to open the FE and connect to the BE fine; it was several steps down the road where the error has occurred).
View 2 Replies
View Related
Oct 20, 2005
I have read through just about every post on this forum related to "Unrecognized Database errors" and have not found a solution to my direct problem.
Stats:
Database is running Access2K on all machines; db is on network location, no sharing issues or permission issues have been identified, no other databases in this network location have had this problem. also, we have tried compact-repair and also have tried re-creating the database and neither have proved successful.
I can open the database just fine if I am the only one opening it. If someone else tries to open it once I have it opened one of the following occurs:
1. Nothing. Hourglass appears for a split second, then nothing happens.
2. Error message "unrecognized database format "mydb.mdb"" appears. If I click OK and both users close the db, it can be opened just fine again by the first user. It doesn't matterwho opens it first, but the second user gets this message.
Any ideas why this is happening?
Thanks!
View 3 Replies
View Related
Feb 11, 2014
I have made a database, splitted it and then made the front end as accde. After that I copied both Front end & back end files in a shared folder. It is working fine as long as I am using it from my computer, but when I go to the other computer and try to open the front end, it gives the message of Unrecognized format error. This problem is only with the accde file, all other files are opening except this.
View 11 Replies
View Related
Jul 15, 2014
Using Access 2007, can I return a value for CurrentProject.FileFormat WITHOUT opening the database?
I'm looking for a way to determine the file version of a given Access database without actually "opening" the database in Access (I don't want it to ever be visible at all or in any way).
So to open a database in Access 2007 "without opening it," I'm using:
Code:
Dim db As DAO.Database
Set db = DBEngine.Workspaces(0).OpenDatabase("C:Path-ToFile.accdb")
From here, there are at least two different "version" indicators that can be used, as in this example:
Code:
Debug.Print db.Properties("Version").Value
Debug.Print db.Properties("AccessVersion").Value
Now, if you run this code on an Access 2002/2003 .MDB file, you will get:
Code:
4.0
09.50
If you run this code on an Access 2007 .ACCDB file, you get:
Code:
12.0
09.50
Note two important factors:The db.Properties("Version") seems to be returning the JET version from what I can see in research. This is NOT what I'm after.
The db.Properties("AccessVersion") returns THE SAME VALUE for an '07 ACCDB as it does for an '02-'03 MDB, since Microsoft never updated it, apparently.
Now.... the one way that I have found that ACCURATELY describes the version of a given access database file is to use:
Code:
Debug.Print CurrentProject.FileFormat
...as this will always return, for example, 2.0 for an Access 2.0 .MDB file; 10 for an Access 2002/03 .MDB file; and 12 for and Access 2007 .ACCDB file (and there are others; these are AcFileFormat bitmask constants as described in Access support).
BUT, this CurrentProject object doesn't seem to be available (so far as I can see) when using the "open without opening" method described above.
SO, is there any way to return the FileFormat value without opening the database visibly? (Merely basing it in the extension isn't right either.... that would be easy but not accurate as several formats use MDB.
View 5 Replies
View Related
Dec 2, 2005
This morning when I got into work, one of the databases I admin died. It has since locked itself open stating it needs to be repaired. However, when you try to, it says it is locked open by machine......However, that machine has been restarted many times and it is still locked open. The database is located on a shared drive. I am assuming that the network drive has locked it open instead of that PC.
Would someone explain why that has happened? As well as how to stop that from happening in the future. This is very frustrating since I have to change other things that are driven by that database, due to the name of the database changing for a short time. Once I can delete the corrupted one, I have to change them back.
View 5 Replies
View Related
Jan 26, 2006
I have an Access 2002 database that won't compact and repair. When I attempt to open it, it tells me that the database is corrupted and needs to be repaired. When I try to repair it, it gives me the following message: Could not find field 'Description'. Then, the next message states that the db cannot be repaired or isn't an Access db. I've downloaded the JetComp.exe tool, but it gives me the message: Error compacting database. I've tried creating a new database and then importing the objects from the corrupted one, but that failed as well. Any advise?
Isharmonic
View 11 Replies
View Related
Nov 22, 2004
Hello guys and gals,
Please could you help me.
My bosses computer hung whilst he had a database open, now on trying to open it again, Access tells us that it needs repair.
When we say yes try to repair Access tells us invalid password,, the DB is password protected on open.
I notice that there is an .ldb file in the folder, is this anything to do with our problem?
Could you tell me if there is any way to retrieve this database?
He doesn't have a current copy.
Please help if you can.
Thanks,
Brian.
Zimbabwe.
View 6 Replies
View Related
Jan 9, 2004
I get message "MS Acces was unexpectedly quit while MS Acces databse was open. Repair database Y/N? " When I try to open the password protected database. I click yes and get an "invalid password" message. Is there anything I can do to get round this or do I just need to use a back-up?
View 4 Replies
View Related
Jan 31, 2006
Hi,
I was wondering if anyone might be able to help me. What i'd like to do is to be able to get the access to trigger compact and repair database tool automatically just before it shuts. Is it feasible? or has to be done manually?
Thank you in advance
View 2 Replies
View Related
Feb 24, 2006
We have a database that users are writing to through an excel form. We have been successfully writing to this for months however we have now run into a problem...
We have tried opening the database outside of the timeframe that users can write to it and are getting an error:
"The Database R:...mdb' needs to be repaired or isn't a database file.
You or another user may have unexpectedly quit Microsoft Access while a Microsoft Access database was open. Do you want to repair the database?
The problem is:
1. The excel form that writes to the database still works. This form inserts a row into a table and then checks that this record exists. When we insert a record the ldb files last updated time changes to the present time.
2. We tried zipping the database, unloading it on a different server and then repairing it. This worked however none of the records insert over the past few days are existant, and the database descreases significantly in size.
I believe the records are in the database as we can still write to it through the excel form which is checking that the record is properly inserted.
Any ideas on how we can recover this data? I tried running a spreadsheet that would select everything from the table but received an error when trying to connect to the database.
View 4 Replies
View Related
Apr 17, 2007
The compact and repair utility is very good.
Since all my record operations are done through menu, I would like to put a command button for this utility also. But I dont know how to do this. Would somebody help? Thanks in advance.
View 2 Replies
View Related
Mar 17, 2008
Hi all,
I ahve come across a small problem and i am wandering if someone can helo me out on this.
I have a programme which is for the fast food and uses a order no for each receipt, now the problem is each time the form is closed and opened the number goes to the next avaialable number so last nunber was 32 the next will be 33 etc this number adding is done by code but i am having a problem somewhere along the lines and it goes back to 1 every so often, so the you have to log off and log in to to to the next available record,
So i was thinking rather having to do the number increment by code why not have a auto number field in there instead, the only problem is at the end of the day the number should go back to 1 for the next day so is there a way to compact and repair the database or better still to zero the tables i wish??
Thank you
Regards
Naym
View 2 Replies
View Related
Jun 30, 2005
How can I recover a curropt database. I know it is possible as a few softwares were able to recover it and they are just a Demo. Does anyone know a freeware available.
Its a matter of urgency.. please help!!!!
View 6 Replies
View Related
Aug 3, 2007
Is it possible to make the database compact and repair itself when it is closed to prevent it becoming too large?
Alternatively, can you create a macro to compact and repair at the click of a button?
Thanks, Steve
View 2 Replies
View Related
Feb 9, 2008
Can anyone give me guidance or code on how to automatically compact and repair.
There is something going on in my database when I open and it goes from 3.7kb to 26 kb each time it is opened - I cant find out why - ope to the why suggestion but another option is to automatically compact and repair
Thanks in anticipation.
Humph
View 2 Replies
View Related
Jun 26, 2007
Hi there,
While i am trying to open the access database its giving me below error:
"Database ###### needs repair or its not access file format"
And i am not able to open it because of that.
Please advise if something can be done.
Thanks
Danny
View 2 Replies
View Related
Dec 6, 2004
Hi all,
I had a form with a command button which invokes email sending option to send a report..I am using code from a sample database . The code which I am using is here:-
'This will create the e-mail
DoCmd.SendObject acReport, "Rpt_Customer", "RichTextFormat(*.rtf)", "", "", , "Customer Report", "", False, ""
'Tbis explains all the section of the e-mail see SendObject in help
Rem example from help DoCmd.SendObject [objecttype][, objectname][, outputformat][, to][, cc][, bcc][, subject][, messagetext][, editmessage][, templatefile]
The code is working perfect and my question is that can I change the file format from RichTextFormat to word format????? I tried by chaning "WordDocument (*.doc)" but it didn't worked???? Is there any way I can change that to word format (*.doc)???? any suggestions appreciated .
thanks in advance
Thanks
View 4 Replies
View Related
