Repair MS Access database without having program installed

Answer Posted / brianhor45

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

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the tools of ms access?

425


Would you like to easily automate your MS Access database through menu driven selections?

489


Can an access database be used online?

471


What are the applications of ms access?

455


What are the benefits of microsoft access?

491






Explain about managing data tasks?

499


What are the components of ms access?

462


What is dynasets in ms access?

510


How we can apply bit m a podded index in ms access

1627


In MS Access the long and short date option does not show 4 digit years. how do I achieve the mm/dd/yyyy format?

499


Can multiple users access the same access database?

398


Do accountants use microsoft access?

448


What are the advantages of ms access?

451


What are queries in ms access?

504


Define Primary key, Foreign key, Weak key in your own words.

2692