Post reply

Repair MS Access database without having program installed

  • August 25, 2015 at 3:34 am

    #73650

    Does anyone know of a program/option/tool to repair a microsoft access database that can be run from command line (I don't want any user interaction, I want to be able to schedule it).

    The systems do not have Microsoft Access installed, they use a Delphi program with ado connections to an ms access db, and the delphi program runs a compact every time it opens, but the db still gets corrupted and needs repair from time to time.

    Currently, I have to log onto the machine, open odbc and do a repair through that, but I would like to be able to schedule a regular repair to run without needing a connection to the db, and hopefully avoiding the user ever seeing the error message.

    So far, all I have been able to find are programs that use a gui interface (which I can do with the odbc), or programs that require ms acess or ms access runtime installed, neither of which exists on these machines.

    Any suggestions are appreciated!

    Thanks

  • August 27, 2015 at 10:07 am

    #1822834

    Is the Access database stored on each user PC, and is it in the .mdb format or the .accdb format?

    Wendell
    Colorful Colorado
    You can't see the view if you don't climb the mountain!

  • September 1, 2015 at 6:03 am

    #1823605

    You can use Recovery Toolbox for Access developed for recovering data from corrupted Microsoft Access databases.

    For more: https://access.recoverytoolbox.com/[/url]

  • September 2, 2015 at 6:27 am

    #1823946

    Use Recovery Toolbox for Access developed for recovering data from corrupted Microsoft Access databases. The MS Access recovery tool is capable of repairing MDB and ACCDB database files.

    For more: https://access.recoverytoolbox.com/[/url]

  • September 24, 2015 at 3:21 pm

    #1829332

    If the database is an JET (.mdb) database then you can use the free Jet Compact tool from Microsoft.

    Boyd Trimmell, Microsoft Access MVP Alumni 2010-2015

    aka HiTechCoach

  • December 15, 2015 at 10:47 am

    #1846142

    Check this.. I use this when the DB is corrupted..

    Before running, make a backup of the DB..

    "C:\Program Files (x86)\Microsoft Office\Office12\MSACCESS.EXE" "C:\AccessDB.accdb" /decompile

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply