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

How do you check if ms access is installed?

669

---

How many columns are in access?

583

---

What is recordset in ms access?

614

---

How do you create an access file?

671

---

The long and short date option in ms access does not show 4 digit years. How would you achieve the mm/dd/yyyy format?

576

---

How can you maintain a relationship between different databases in access?

721

---

Can you download access on mac?

571

---

Is there a substitute for microsoft access?

617

---

Explain table queries and select queries.

617

---

What is a domain in microsoft access?

606

---

Explain how ms access is better than ms sql server?

644

---

Difference between superior keys and candidate keys?

651

---

What objects are present in the table msysobjects of microsoft access database?

635

---

What is microsoft access used for in real life?

602

---

Suppose you are designing an access database form. How will you get your next control in the form to be automatically selected?

624

---