URGENT - Corupt A97 MDB Cant Repair or Compress
I have a database called descriptions.mdb, yesterday when one of my co-workers is working on it through interdev, saves his changes, then closes Access then releases it on interdev so the new file can get back up to the server, he later checks it to see if the data came through, and now we cant even open the data, Access97 Keeps saying it's an unknown format, or that it has become corupt, I need to know how I can repair this, I tried looking at the hex of the database, the data seems to be all there and intact, and is roughtly the same size as a three weeks old backup copy, but we cannot get it to read.
Also tried opening it in Access2000 and running it's Repair utility, same message, the database is definitly Access97 though.
Karl
kb244@kb244.com
http://www.kb244.com
Experienced in : C++(both VC++ and Borland),VB1(dos) thru VB6, Delphi 3 pro, HTML, Visual InterDev 6(ASP(WebProgramming/Vbscript)
http://www.brainbench.com/transcript.jsp?pid=629151
RE: URGENT - Corupt A97 MDB Cant Repair or Compress
If so try another and so on.
DougP, MCP
dposton@universal1.com
Ask me how Bar-codes can help you be more productive.
RE: URGENT - Corupt A97 MDB Cant Repair or Compress
Karl
kb244@kb244.com
http://www.kb244.com
Experienced in : C++(both VC++ and Borland),VB1(dos) thru VB6, Delphi 3 pro, HTML, Visual InterDev 6(ASP(WebProgramming/Vbscript)
http://www.brainbench.com/transcript.jsp?pid=629151
RE: URGENT - Corupt A97 MDB Cant Repair or Compress
Also, You might try to compact either the orig. or the copy.
Doug Poston's approach can also help.
MichaelRed
mred@duvallgroup.com
There is never time to do it right but there is always time to do it over
RE: URGENT - Corupt A97 MDB Cant Repair or Compress
Lately I've been looking through hex data trying to recover what I can.
I Cant repair, I Cant compact, I cant open, I cant import, I cant do anything if the DB wont even open.
Karl
kb244@kb244.com
http://www.kb244.com
Experienced in : C++(both VC++ and Borland),VB1(dos) thru VB6, Delphi 3 pro, HTML, Visual InterDev 6(ASP(WebProgramming/Vbscript)
http://www.brainbench.com/transcript.jsp?pid=629151
RE: URGENT - Corupt A97 MDB Cant Repair or Compress
Sorry about your loss. Depending on the activity level and what you are able to recover from the 'trash' remains, it might be worth the effort to start w/ the back-up, and only recover differences.
I know this is not what you want to here, but this is the object lesson for DAILY backups and transaction logs maintained in a seperate database.
MichaelRed
mred@duvallgroup.com
There is never time to do it right but there is always time to do it over
RE: URGENT - Corupt A97 MDB Cant Repair or Compress
Karl
kb244@kb244.com
http://www.kb244.com
Experienced in : C++(both VC++ and Borland),VB1(dos) thru VB6, Delphi 3 pro, HTML, Visual InterDev 6(ASP(WebProgramming/Vbscript)
http://www.brainbench.com/transcript.jsp?pid=629151
RE: URGENT - Corupt A97 MDB Cant Repair or Compress
I agree with you re " ... arn't supposed to ... ", unfortunatly, my experience goesa along with the premise of " ... shoulda, woulda, coulda. Spit (or whatever you choose) in one hand and wish in the other. See which one gets full first.
In one of my (long gone) 'jobs', the nework folks ASSURED me that there was a daily back up. When (note it is ALWAYS when - never IF) the system crashed and the database was thoroughly corrupted (a-la-your situation, I was pollietly informed that the back up system just skipped any 'file' ehich was in use when the backup got to it, and left a message on the SYSTEM console noting that the file was not in the backup - AND that for something over three weeks there had always been someone in the file (database) when t he back up was supposed to occur. Further, it was NOT in their policy to notify ANYONE that a backup had failed. I ALMOST kept the job, because I had both my own backup and the 'Seperate' transaction log, so was - with only a LOT of angst - able to re-build the dataset in about two hours. BTW, the transaction log showed who was 'logged-on' for those 'wee hours' of the morning, adn that they were not doing any 'work' The individual said they just didn't want to have to re-connect (over a dial-up modem), and staying in the db was convenient. If I had 'kept' the job, I would have instuituted a time-out disconnect feature IMMEDIATLY. That didn't happen.
MichaelRed
mred@duvallgroup.com
There is never time to do it right but there is always time to do it over
RE: URGENT - Corupt A97 MDB Cant Repair or Compress
Thanks for your help, advice
oh heres one for you Michael (just say it really fast, it annoys some people when they ask you for something)
"I Would If I could, but I can't so I won't."
Karl
kb244@kb244.com
http://www.kb244.com
Experienced in : C++(both VC++ and Borland),VB1(dos) thru VB6, Delphi 3 pro, HTML, Visual InterDev 6(ASP(WebProgramming/Vbscript)
http://www.brainbench.com/transcript.jsp?pid=629151
RE: URGENT - Corupt A97 MDB Cant Repair or Compress
Karl
kb244@kb244.com
http://www.kb244.com
Experienced in : C++(both VC++ and Borland),VB1(dos) thru VB6, Delphi 3 pro, HTML, Visual InterDev 6(ASP(WebProgramming/Vbscript)
http://www.brainbench.com/transcript.jsp?pid=629151
RE: URGENT - Corupt A97 MDB Cant Repair or Compress
re your side note.
I think it's like the "un-sportsman like conduct" penalties. It's who throws the SECOND punch that gets the penalty! In that specific instance, I was on a contract, while all others were "employees". You tell me who gets to 'HANG'.
MichaelRed
mred@duvallgroup.com
There is never time to do it right but there is always time to do it over
RE: URGENT - Corupt A97 MDB Cant Repair or Compress
Karl
kb244@kb244.com
http://www.kb244.com
Experienced in : C++(both VC++ and Borland),VB1(dos) thru VB6, Delphi 3 pro, HTML, Visual InterDev 6(ASP(WebProgramming/Vbscript)
http://www.brainbench.com/transcript.jsp?pid=629151
RE: URGENT - Corupt A97 MDB Cant Repair or Compress
I have always made more $$$ as a consultant or on contract work than on the wage slave side (and I mean more even after paying a lot more for the 'benies' (read insurance and retirement).
And I really don't like having to work for "&%$#&%$#substitute your current favorite four letter description, so the independent side of me looks at the situation as an opportunity (it compensates for my laziness in not looking for a better place to begin w/).
BUT I really don't like being tarred w/ the brush dipped in the "employee's" toilet.
So, in the end I just go away into the sunset, with both positive and negative thoughts. I hope i still have better things to do in life than tilting at the windmills.
MichaelRed
mred@duvallgroup.com
There is never time to do it right but there is always time to do it over