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 I convert an access database to excel?

416

---

What are the basic features of ms access?

411

---

What is the role of where clause in ms access?

439

---

How do you create a database in microsoft access?

467

---

Explain table queries and select queries.

469

---

---

How does microsoft access database recover free space?

432

---

You are required to create a macro that can run action query. What steps will you take?

473

---

What is query in ms access?

417

---

What is the use of microsoft access 2010?

447

---

What are the important data types in ms access?

430

---

How do you link data in access?

445

---

How do I get microsoft access 2016?

446

---

What is the function of ms access?

436

---

What is the use of pivot table?

485

---

By using Macromedia Director How to fetch the data from Microsoft Excel?

1843

---