Results 1 to 5 of 5
  1. #1
    Join Date
    Jan 2004
    Posts
    8

    Unanswered: Unrepairable database

    Hi,

    A customer sent me his corrupt database and I tried to repair it. No way, I could not even open it.
    When I observed the data ina viewer, I noticed that the file did not start with four hex bytes <00><01><00><00>, but with 'SZDD'. Text that is readable in a normal database, seems to be corrupted/encrypted? in this database.
    Maybe this database is opened and saved with another program, although our customer says it isn't (they always say so...). Does anyone recognize this 'SZDD' sequence??

  2. #2
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740
    google throws up tons of stuff for "SZDD header" - no idea if it is in any way relevant to your situation tho!

    izy
    currently using SS 2008R2

  3. #3
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    You could try repairing thru the ODBC ...
    Back to Access ... ADO is not the way to go for speed ...

  4. #4
    Join Date
    May 2004
    Location
    New York State
    Posts
    1,178
    Try this for a quick and dirty. I've done it before successfully.

    Open Access and create a new database. In the new database, click on the File menu, go to Get External Data, and select Import. In the dialog box, make sure you select the proper database type, and select your customer's database. In the various tabs of the Import dialog box, click on Select All. Open the Options, and make sure you import every possible feature. Click OK to start the import, and sit back. I betcha you'll be OK.

    Good luck,
    Sam

  5. #5
    Join Date
    Jan 2004
    Posts
    8
    I found out that the 'SZDD' sequence means that the file is compressed with Microsoft's own Compress.exe. Unfortunately, after using Expand, the database is corrupt in some way, so I cannot recover it completely.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •