Results 1 to 2 of 2
  1. #1
    DonShort is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Nov 2015
    Posts
    1

    Question Repair MS Access database without having program installed

    ThanksAny suggestions are appreciated!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.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. 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. 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).


  2. #2
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 8 Access 2013
    Join Date
    Aug 2013
    Posts
    7,862
    You can use command line switches, however, I believe you will need to have Access installed on the machine that executes the RT.
    https://support.office.com/en-us/art...8-1F5DF9702BF1

    Also, there is no guarantee that Compact and or Repair will fix the issues you have with your backend file. These sorts of things are best managed at Design Time, when developing the backend and or front end/UI, before the corruption occurs.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 4
    Last Post: 09-14-2015, 12:33 PM
  2. Access database repair
    By Arjun4 in forum Access
    Replies: 7
    Last Post: 05-11-2015, 12:27 PM
  3. Replies: 1
    Last Post: 03-19-2014, 12:08 PM
  4. Replies: 1
    Last Post: 04-05-2013, 09:48 AM
  5. C program: read/write Access database
    By serendipity1276 in forum Programming
    Replies: 1
    Last Post: 08-15-2011, 01:15 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums