CORRUPT ACCESS 2000 DATABASE - URGENT!
Yossi Tamman
WITH ACCESS 2000 SR-1
I have a database file which does not work anymore.
It was password protected.
When I open it I put the passaword in, like usual, then I get (brackets {}
and [] are my comments):
" The database {so and so} needs to be repaired or isn't a database file.
You or another user may have unexpectedly quit [NOT TRUE] Microsoft Access
while a Microsoft Access Database was open.
Do you want Microsoft Access to attempt to repair the database?"
I click Yes
Then I Get:
"NOT A VALID PASSWORD"
Then
"The database {so and so} can't be repaired or isn't a database file"
and finally
"NOT A VALID PASSWORD"
I have tried do import to a new database, with exactly the same result.
I have tried to compress and repair, with the same result.
I have tried to open the application and file with /repair and also with
/decompile parameters: same result.
I DO NOT HAVE A RECENT BACKUP.
Any trick, utility, program or service - even non free - welcome!!
please HELP!!!
Michael (michka) Kaplan
Sounds like you may have opened it in Word. See the TSI Word to the Wise
utility to help keep this from happening, on the utilities page at:
--
MichKa
a new book on internationalization in VB at
http://www.i18nWithVB.com/
"Yossi Tamman" <JOE_B...@email.msn.com> wrote in message
news:uPX4xX2RAHA.290@cppssbbsa04...
Dennis Sheridan
let me tell you that I had almost this exact same problem just a few days
ago. My story does not have a happy ending. One month of data was lost due
to a catastrophic corruption of my database. I delegated the backup
procedure and never followed up. Big mistake.
Anyway, I posted my story to another newsgroup and received the following
reply from a gentleman named Larry Linson. This was such a knowledgeable and
welcomed message that I am sharing it with you verbatim at the risk of
crossing Mr. Linson for not consulting him first. I wish you good luck. Here
it is:
-start---------
The usual cause for corruption in a multiuser environment is "ungraceful
termination". Power outage, users powering down while an Access app is
running, and network problems are the usual culprits. Your description of
"crude Win95 peer network" may have identified the problem.
You have one more hope, given what you've tried. Go to
http://www.microsoft.com/downloads/ and download the Jet 3.5 Update
JET35UPD.EXE. When you unpack it there will be a separate utility named
JETCOMP. It can sometimes recover where the built-in Compact and Repair
cannot.
If it doesn't, then you'll need to recover from your most recent backup.
If you don't have a recent backup, then my late Mother would tell you that
you should consider it a character-building experience and learn from your
mistakes. <G> Goodness knows, she told that to me enough times.
An alternative, albeit not a free one, would be to contact Peter Miller at
http://www.pksolutions.com. He has a very good reputation for success at
data recovery.
-end---------
Douglas J. Steele
using Access 2000
--
Doug Steele, Microsoft Access MVP
Beer, Wine and Database Programming. What could be better?
Visit "Doug Steele's Beer and Programming Emporium"
http://I.Am/DougSteele/
Dennis Sheridan <da...@ix.netcom.com> wrote in message
news:8uk679$k40$1...@nntp9.atl.mindspring.net...
Michael (michka) Kaplan
compact programatically and not via Access for some specific corruption
bugs.
--
MichKa
a new book on internationalization in VB at
http://www.i18nWithVB.com/
"Douglas J. Steele" <djst...@idirect.com> wrote in message
news:uCsy$1CTAH...@cppssbbsa02.microsoft.com...
robor...@gmail.com
I want to suggest you for a data recovery software with the help of any third party data recovery software you can restore your access database file again there are so may software which help you one of them is Recoveryfix for Access database you can try it and download it from here http://www.repairaccess.net/