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

What is the maximum size of ms access database?

802

---

Why do you link tables in access?

875

---

What is field size access?

743

---

What is a super key? How is it different from a candidate key?

807

---

What is a query in access?

838

---

How many rows can you have in an access table?

834

---

What are modules in ms access?

787

---

Is there a substitute for microsoft access?

892

---

How would you remodel an existing access database?

935

---

What is accounting access?

819

---

What are the tools of ms access?

789

---

What does <> mean in access query?

912

---

Is microsoft access user friendly?

841

---

What is recordset in ms access?

833

---

Explain about managing data tasks?

861

---