How to repair Access database ?

A

adomwatson

New Member
Joined
Apr 17, 2013
Messages
2
Reaction score
0
My access database is corrupt and i can't able to access any files of it. So, any one can please suggest me the appropriate solution that allow me proper steps for repair Access database. :confused:
 
adomwatson said:
My access database is corrupt and i can't able to access any files of it. So, any one can please suggest me the appropriate solution that allow me proper steps for repair Access database. :confused:
Click to expand...

Your first mistake was using Access in the first place. Your second mistake was not having a backup.
 
Right click on your Access file and choose properties. If you are in luck and Shadow Copies is enabled on that hard disk, you might have a tab called previous versions, you may have previous versions that you may be able to roll back to if you can't fix the corrupt file and don't have a good backup.
 
To repair access database

adomwatson said:
My access database is corrupt and i can't able to access any files of it. So, any one can please suggest me the appropriate solution that allow me proper steps for repair Access database. :confused:
Click to expand...

Hey Adom,
Hmm.... You can easily repair access database because in market arena there are so many solutions available. By reading your query I think you lost your crucial data. Read the article http://www.articlesfactory.com/articles/computers/use-brilliant-repair-tool-for-access-database-recovery.html. It will help you into resolving your query...........
 
And please, do yourself a favour, if your data is important to you and you want good peformance, start using a proper relational database server like SQL Server or MySQL instead of Access.
 
I have some access experience if you need someone to take a look at the file.

Some time ago I got a client who is using access on roughly 150 workstations and I seriously suggest that you look at other options. Any IT person pushing Access should be fired on the spot for sabotage.
 
deweyzeph said:
And please, do yourself a favour, if your data is important to you and you want good peformance, start using a proper relational database server like SQL Server or MySQL instead of Access.
Click to expand...

People seem allergic to mysql (don't trust oracle) these days and going for mariadb.
 
+1 to moving to a 'proper' db system.

/dons flame suit

That said, Access has it's place and does a good job for certain requirements. I've got extensive experience with rather complex Access "systems" and if properly designed and maintained then they ran pretty well even in fairly large multi user environments. The most common 'problem' I came across was usually an issue caused by the design of db or dodgy vba code. As a 'front-end' for SQL Access can be quite useful.

My suggestion - try a compact + repair and if that doesn't work or isn't possible then create a new db and import everything from the old one? If that fails then you have a bigger problem and you'll probably need some 3rd part tool to help you. As stated above, Google will help you...
 
kellyleon said:
Hey Adom,
Hmm.... You can easily repair access database because in market arena there are so many solutions available. By reading your query I think you lost your crucial data. Read the article http://www.articlesfactory.com/articles/computers/use-brilliant-repair-tool-for-access-database-recovery.html. It will help you into resolving your query...........
Click to expand...

Hey thankyou so much. your solution is really appreciable. It resolve my query in correct way. Now i can access my database without any error. I suggest all to read the article. Thankyou so much
 
adomwatson said:
My access database is corrupt and i can't able to access any files of it. So, any one can please suggest me the appropriate solution that allow me proper steps for repair Access database. :confused:
Click to expand...

kellyleon said:
Hey Adom,
Hmm.... You can easily repair access database because in market arena there are so many solutions available. By reading your query I think you lost your crucial data. Read the article http://www.articlesfactory.com/articles/computers/use-brilliant-repair-tool-for-access-database-recovery.html. It will help you into resolving your query...........
Click to expand...

adomwatson said:
Hey thankyou so much. your solution is really appreciable. It resolve my query in correct way. Now i can access my database without any error. I suggest all to read the article. Thankyou so much
Click to expand...

adomwatson - 2 post wonder, joined April 2013
kellyleon - 1 post wonder, joined April 2013

Smells like some cultured spam to me...
 
Thread Necro warning.

So a client got hit with this .wallet ransomware on Monday and so far i have been able to restore all the data (+/- 3tb ) affected. Everything except an Access 2013 Database (yes i know he should be shot for using access) which is corrupted.

Backups were also corrupted by this ransomware, and shadow copies were also deleted.

I have tried the tools available online, compact and repair etc. with no luck.

Any Access fundi's out there that may be able to help? The DB is 250mb in size and has some critial data for an in-house application that they use, but cannot be accessed.

Any help will be greatly appreciated and many a beer etc will flow if i can get this data back.
 
Access should not be used for critical data.
They should have migrated to a MSSQL, or even MySQL back-end ages ago.

Recovering is going to be close to impossible.
Have no backups been made to another machine?
 
Nod said:
Access should not be used for critical data.
They should have migrated to a MSSQL, or even MySQL back-end ages ago.

Recovering is going to be close to impossible.
Have no backups been made to another machine?
Click to expand...

I hear you, been screaming about this since we started supporting them.

No backups on other machines unfortunately
 
Last edited:
I followed these steps, but I was not lucky. I guess I will not be able to retrieve the data in Access 2010 anymore. I saw tools like AccessFIX but it is not free, so I do not know what to do

notnät
Definiciones de not
adverbio
used with an auxiliary verb or “be” to form the negative.
he would not say
sustantivo
a Boolean operator with only one variable that has the value one when the variable is zero and vice versa.
adjetivo
(of paper) not hot-pressed, and having a slightly textured surface.
3 definiciones más


Nod said:
Backups and a better technical solution is never important or urgent, until the crap hits the fan ...

Would this help?
https://www.stellarinfo.com/blog/repair-ms-access-database-file-recover-data/
You probably tried *everything* already :)
Click to expand...
 
Last edited:
You must log in or register to reply here.
Back
Top
Sign up to the MyBroadband newsletter
X