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 the use of where clause in ms access sql?

806

---

Can you insert and retrive images in msaccess using java? If yes, how?

787

---

How you can import data from other sources into access database?

937

---

How many rows ms access can handle?

843

---

How many types of table create in ms access?

765

---

What is the difference between excel and access?

883

---

You need to migrate the ms access database tables to oracle. What steps will you take?

773

---

Is access better than excel?

848

---

Explain the foreign key?

803

---

Does office 365 include access database?

707

---

Which is better mysql or ms access?

800

---

How do you link data in access?

875

---

What are the basic features of ms access?

908

---

What is the max size for access database?

840

---

What are queries in ms access?

856

---