question

olavbung avatar image
olavbung asked

MS Access detected corruption in database

Hi to all, I have Windows 7 in my laptop inside which I use MS Office 7. I have created some database files in MS Access. Now when they try to open those database files to modify the data something stops them to go further. I see error something like this: "Microsoft Access has detected corruption in this file." Is there anyone who can take me out from this problem? Thank you!
databasemicrosoft-access
1 comment
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

A few things to check additional to my question. How big is the DB? Have you exceeded the 2gb limit? Also what version of Access are you using? Do you mean 2007?
0 Likes 0 ·
jelinekbor avatar image
jelinekbor answered
-Try to import the data inside a new database file. -Checked those database files in your MS Access program. -May be there is a problem with your clients' program. -Open those database files in some other MS Access. In case actions on above dont work in your situation, see more resources, which might be effective here [ http://www.filerepairforum.com/forum/microsoft/microsoft-aa/access/1420-ms-access-corrupt-database][1] - where you may know more about actons after corruption ms access database [ https://access.recoverytoolbox.com/][2] - paid solution, which is represented by *Recovery Toolbox for Access*, but if nothing works, it can become the proper and unique decision. [1]: http://www.filerepairforum.com/forum/microsoft/microsoft-aa/access/1420-ms-access-corrupt-database [2]: https://access.recoverytoolbox.com/
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

@SQLShark avatar image
@SQLShark answered
There are ways to resolve this however the easiest would be to use a backup (assuming you have backups). Have you tried to repair the database (using compact and repair). Is the Access DB using the JET/ACCDB engine or SQL Server? If you have no BU and C&R does not work then look at these links. [ http://www.everythingaccess.com/tutorials.asp?ID=Access-Database-Corruption-Repair-Guide][1] [ http://support.microsoft.com/en-us/kb/306204][2] [1]: http://www.everythingaccess.com/tutorials.asp?ID=Access-Database-Corruption-Repair-Guide [2]: http://support.microsoft.com/en-us/kb/306204
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

edwards142 avatar image
edwards142 answered

Hey Olavbung,

I think I can help you out to fix this specific MS Access database "Microsoft Access has detected corruption in this file." error. I am assuring you because when I stuck with the same error, I have searched a lot for the fixes and got this manual fix. So, follow the below mentioned software:

Firstly, you need to create a blank database = “C:\ Recover_db.mdb”. Then Close and exit.

After it create another blank database and navigate to Modules Tab.

Then Click on New and Paste the given below code

Dim db As DAO.Database
Set db = DAO.OpenDatabase(”C:Corrupt_db.mdb”)
Dim xtable As TableDef
For Each xtable In db.TableDefs
If Mid(xtable.Name, 1, 4) <> “MSys” Then
rSQL = “SELECT * INTO [” & xtable.Name & “] IN ” &
_“‘C:Recover_db.mdb’” & _
” FROM [” & xtable.Name & “]”db.Execute
rSQL End If Next xtable MsgBox “Process Complete.”
End Function

“Microsoft DAO 3.6 Object Library”. After then tap to the OK button and go to the Menu tools, choose References.

On the Module Window, tap to the Recover_db() Function. At the end verify your database file names after setting up correctly and then press the F5 button.

10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.