Access Database Corrupt. Please Help - HotUKDeals
We use cookie files to improve site functionality and personalisation. By continuing to use HotUKDeals, you accept our cookie and privacy policy.
Get the HotUKDeals app free at Google Play

Search Error

An error occurred when searching, please try again!

Login / Sign UpSubmit

Access Database Corrupt. Please Help

£0.00 @
Hi all, I have an access database which has become corrupt. Does anone know of a free tool to fix this. Everything I have downloaded requires you to pay to save the recovered article. Thanks …
07sanchez Avatar
7y, 5m agoPosted 7 years, 5 months ago
Hi all,

I have an access database which has become corrupt.

Does anone know of a free tool to fix this. Everything I have downloaded requires you to pay to save the recovered article.

Thanks in advance
07sanchez Avatar
7y, 5m agoPosted 7 years, 5 months ago
Options

All Comments

(13) Jump to unreadPost a comment
Comments/page:
#1
What version of Access are you using? If I remember correct in Office 2003 you have the option of repair the db.

Try this: http://office.microsoft.com/en-us/access/HP051874491033.aspx
#3



Not nice to rush to judgement.

I have googled it and tried all the help guides. It is beyond access repair and i can't import into a new DB as the corruption is that bad

I need to use a piece of software which will restore. But they are all pay ones. All the ones show me the DB and allow me to see but wont fix till I pay.

I was simply wondersing if anyone knew a decent free one.
banned#4
07sanchez
Not nice to rush to judgement.

I have googled it and tried all the help guides. It is beyond access repair and i can't import into a new DB as the corruption is that bad

I need to use a piece of software which will restore. But they are all pay ones. All the ones show me the DB and allow me to see but wont fix till I pay.

I was simply wondersing if anyone knew a decent free one.


you should inform us of all the steps you have taken to avoid unneccesary posts and for us to help you with a conclusion asap

link us the software you have found which you think will help you
#5
Looks like all of the available "free" software has to be paid for to actually recover the database.
#6
kapows
you should inform us of all the steps you have taken to avoid unneccesary posts and for us to help you with a conclusion asap

link us the software you have found which you think will help you


agreed op shouldn't assume we 'know' what they've already done

but why o why did you not back up?

a memory stick just left in your pc/laptop and every 5/10mins save.
#7
Predikuesi
Looks like all of the available "free" software has to be paid for to actually recover the database.


Yeah looks that way. Shame

Alfonse
agreed op shouldn't assume we 'know' what they've already

but why o why didn't you not back up?

a memory stick just left in your pc/laptop and every 5/10mins save.


I have a backup but a day earlier and I had completed quite a lot of work
#8
Can you access any of the data via code - Python, .Net or even link in Excel (ODBC) and depending on the data you've got save as csv and reimport to a new DB.

(If you can use something like Sql Express or MySql instead of Access)
#9
I'll reiterate the first question as we have yet to establish the most fundamental piece of information in order to resolve the issue...

Spriggan
What version of Access are you using?...


BFN,

fp.
#10
I'm not sure if this will work for Access but worked for Word and Excel fixing corrupt or oversized documents.

Download and install OpenOffice (It's legit don't worry, just don't install the toolbar it wants) and try opening the Access DB within the database program. Save As a new file and try opening it in MS Access.

I think there is also a 'repair' option in Access (Under tools I think) and also possibly within OpenOffice. Try that first (make a copy if you wish just in case).

Try OO though, that trick worked for me :) You can uninstall it after if you want.
#11
The way to repair the database is to perform a Compact operation.

Python and ODBC linking via Excel is futile. Anyway, Python is a scripting language and has no API commands to read Access files. .NET isn't a programming language as such but more of an architecture. You will need to understand the format and metadata to read the database using a programming language like C++. If you do use the programming approach, you can use the ODBC API (via DAO or ADO) commands to attempt opening recordsets and obtaining field values but I suspect that ODBC linking will fail as the database cannot be read - Access uses ODBC linking to read the database schema and the data so if it fails then doing it programatically is likely to fail. Try the option to Compact the database. You can also try to import the data. The Import option from OpenOffice, as menitoned above, is also worthwhile but Access has its own import too.
#12
ElliottC
Python and ODBC linking via Excel is futile.


Generally agreed. However, in a similar position and with data to access I'd be willing to try.

ElliottC
Anyway, Python is a scripting language and has no API commands to read Access files. .


http://mail.python.org/pipermail/python-win32/2006-March/004420.html

http://www.easysoft.com/developer/languages/python/index.html

"The tutorials in this section show how to connect Python to remote databases such as SQL Server, Oracle and Access by using the ODBC-enabled DB-API modules pyodbc and mxODBC."

ElliottC
.NET isn't a programming language as such but more of an architecture.


I would have expanded on this with specifying C# or Vb.net, however as per previous point I don't think this will help the OP with the DB - still worth a shot though.
#13
john-boy
Generally agreed. However, in a similar position and with data to access I'd be willing to try.



http://mail.python.org/pipermail/python-win32/2006-March/004420.html

http://www.easysoft.com/developer/languages/python/index.html

"The tutorials in this section show how to connect Python to remote databases such as SQL Server, Oracle and Access by using the ODBC-enabled DB-API modules pyodbc and mxODBC."



I would have expanded on this with specifying C# or Vb.net, however as per previous point I don't think this will help the OP with the DB - still worth a shot though.


I stand corrected! Python is more powerful than I thought - even object-oriented.

Post a Comment

You don't need an account to leave a comment. Just enter your email address. We'll keep it private.

...OR log in with your social account

...OR comment using your social account

Looking for Twitter login?
Thanks for your comment! Keep it up!
We just need to have a quick look and it will be live soon.
The community is happy to hear your opinion! Keep contributing!