How to repair Access database ?

[adomwatson]

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.

 

[egenis]

Starting point here:

https://www.google.co.za/search?q=repair+corrupt+access+database&aq=0&oq=repair+corrupted+access&aqs=chrome.1.57j0l3.6599j0&sourceid=chrome&ie=UTF-8

 

[guest2013-1]

Starting point here:

https://www.google.co.za/search?q=repair+corrupt+access+database&aq=0&oq=repair+corrupted+access&aqs=chrome.1.57j0l3.6599j0&sourceid=chrome&ie=UTF-8

I like you

 

[Ancalagon]

Starting point here:

https://www.google.co.za/search?q=repair+corrupt+access+database&aq=0&oq=repair+corrupted+access&aqs=chrome.1.57j0l3.6599j0&sourceid=chrome&ie=UTF-8

Sorry can you repeat step one please?

 

[deweyzeph]

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.

Your first mistake was using Access in the first place. Your second mistake was not having a backup.

 

[InvisibleJim]

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.

 

[kellyleon]

To repair access database

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.

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...........

 

[deweyzeph]

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.

 

[Jimmeh]

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.

 

[ponder]

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.

People seem allergic to mysql (don't trust oracle) these days and going for mariadb.

 

[MartyMarts]

+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...

 

[Nod]

Once you get it working again, follow this: http://dev.mysql.com/doc/refman/5.0/en/connector-odbc-examples-tools-with-access.html

 

[adomwatson]

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...........

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

 

[MartyMarts]

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.

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...........

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 - 2 post wonder, joined April 2013
kellyleon - 1 post wonder, joined April 2013

Smells like some cultured spam to me...

 

[HunterGR]

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.

 

[Nod]

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?

 

[HunterGR]

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?

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

No backups on other machines unfortunately

 

[Nod]

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

No backups on other machines unfortunately

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

 

[ugarte]

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

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

 

[DUDE!@##$%%]

ummmmmmmmmmmmmmmmmmmmmmmmmmmmm backups? why not?!