Results 1 to 9 of 9
  1. #1
    Join Date
    Sep 2002
    Location
    South Wales
    Posts
    580

    Lightbulb Unanswered: Unrecognized Database Format

    Oh dear...

    Using MS Access 2000 Seperate front-end and back end.

    I am getting an error when trying to access this DB

    "Unrecognized database format" which I beleive is a corruption in the back-end.

    I cannot open the back-end seperately and have tried importing objects into a new DB but get the same error.

    Access attempts to repair the DB but then causes an invalid page fault.

    Is this MDB truly screwed? Or has anyone got any suggestions?

    Just about to reach for the backups, coffee and cigs!
    Windows Server 2003-8 / Terminal Services / SQL 2000 / Access 2003 / Office 2003-7 / Exchange 2003-7 / Blackberry Enterprise Server / AutoCAD / Lambert And Butler / Red Bull

  2. #2
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Try this: ( and I've posted on this before ...)

    Create a system DSN pointing to the back-end DB.
    Run the repair option within the ODBC DSN.

    This should work.

  3. #3
    Join Date
    Sep 2002
    Location
    South Wales
    Posts
    580

    Attempting repair

    Thanks for your tip.

    Still no luck though.

    Added system dsn pointing to backend and tried "repair"
    (from more than 1 machine / os) both gave errors and did not repair be

    I have a backup from 3 weeks ago which works.

    AND THE LESSON FOR TODAY IS...BACKUP, BACKUP, BACKUP
    (Wanders off hitting self on head)
    Windows Server 2003-8 / Terminal Services / SQL 2000 / Access 2003 / Office 2003-7 / Exchange 2003-7 / Blackberry Enterprise Server / AutoCAD / Lambert And Butler / Red Bull

  4. #4
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Gareth,

    Is the backend password protected? If so you need to open the ADvanced tab in the DSN and type in the user name Admin and the db password. And then save. Also, what version of Access db is this?

  5. #5
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Another thought: going thru the front door (re: access IDE) and trying to run that repair goes BOINK too huh?

    How big is this backend DB?

  6. #6
    Join Date
    Sep 2002
    Location
    South Wales
    Posts
    580

    Back End

    Thanks for your help here...

    The Back-end is NOT password protected

    Tried to open throught the access (2000) interface...
    (On a W98 and W2000 o/s) machine comes up with the error as attached

    Clicking "Yes" presently starts repair then either crashes out or (as it is doing at the moment - mouse changes from hourglass to pointer despite repair progress bar not completing...)

    Will keep you posted.

    Although I have lost some data here, worst case scenario I can use my most recent backup and get typing.

    However, would be interested to find out how it got screwed!
    Attached Thumbnails Attached Thumbnails error.bmp  
    Windows Server 2003-8 / Terminal Services / SQL 2000 / Access 2003 / Office 2003-7 / Exchange 2003-7 / Blackberry Enterprise Server / AutoCAD / Lambert And Butler / Red Bull

  7. #7
    Join Date
    Sep 2002
    Location
    South Wales
    Posts
    580

    Size

    Backend shows...41.5mb
    Windows Server 2003-8 / Terminal Services / SQL 2000 / Access 2003 / Office 2003-7 / Exchange 2003-7 / Blackberry Enterprise Server / AutoCAD / Lambert And Butler / Red Bull

  8. #8
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Gareth,

    The backend DB itself is an Access 2000 db? If the DSN (ODBC repair) doesn't work then you are screwed ... Backup is your only other recourse ...

  9. #9
    Join Date
    Sep 2002
    Location
    South Wales
    Posts
    580

    Unhappy Many Thanks

    Thanks for your help...looks like Im screwed then!

    Tried all the usual...importing into another db, linking etc. - no joy.

    Will have to use backup - looks like there are only 100 jobs missing...could have been worse I suppose.

    Thing that worries me though, is what CAUSED the corruption!
    Windows Server 2003-8 / Terminal Services / SQL 2000 / Access 2003 / Office 2003-7 / Exchange 2003-7 / Blackberry Enterprise Server / AutoCAD / Lambert And Butler / Red Bull

Posting Permissions

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