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

Explain about managing data tasks?

795

---

What is the maximum number of rows in access 2010?

812

---

Where is microsoft access located?

766

---

What is ms access and features?

760

---

What are queries in ms access?

849

---

List the advantages of access database ovr oracle database.

738

---

What is query in ms access?

688

---

Difference between superior keys and candidate keys?

868

---

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

720

---

What is the advantage of ms access?

804

---

can we call primary key a 'address'????

2371

---

What joins are and how you can open the database in access?

805

---

Is microsoft access user friendly?

786

---

List some file extensions of microsoft access.

902

---

Is microsoft access used anymore?

764

---