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 there a version of microsoft access for mac?

904

---

Explain table queries and select queries.

861

---

How do I open an access database?

869

---

What are the benefits of ms access?

903

---

Explain how you can build a relationship between the different databases in access?

938

---

How can we create a simple query in ms access?

871

---

Do accountants use microsoft access?

848

---

What are the several file extensions in ms access?

1030

---

What are the data types in ms access?

932

---

State the criteria which a trusted publisher should meet before adding him?

901

---

How do you add a serial number to an access report?

868

---

How we can do multi-join query in ms access?

867

---

What is dao recordset in access?

986

---

What can I use microsoft access for?

866

---

How are queries run in ms access? List different ways.

813

---