Answer / 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

Answer / leeramsx

Use Recovery Toolbox for Access developed for recovering data from corrupted Microsoft Access databases.
For more: https://access.recoverytoolbox.com/

I have a reference table called 1. of 2 fields called 1.BadgeGroups(BG)and 1.Badges(B)like BG G aa 10 aa 11 bb 12 bb 13 bb 14 Using MS Design View Table 2 has 3 fields called 2.name, 2.badgegroup and 2.group In Table 2 called 2. they calls Table 1 for 2 fields BUT with the second field 2.badges, I want the combo box only to display the 1.badges where 2.badgegroup = 1.badgegroup The current select I have is for Table Data View Row Source is: 2.badgegroup is filled from a Combo box using Select Distinct etc from Table 1. Tried different syntax's but still lost, looking for some help SELECT 1.[BadgeGroup], 1.Badge FROM 1. WHERE 1.[BadgeGroup]=Me.2.BadgeGroup); I can populate 2.badgegroup with a

0 Answers  

---

What is ms access and features?

0 Answers  

---

What things to be taken in consideration for lookup fields?

0 Answers  

---

What is access best used for?

0 Answers  

---

What is the use of microsoft access 2010?

0 Answers  

---

How is super key different from a candidate key?

0 Answers  

---

Does anyone still use microsoft access?

0 Answers  

---

How do I create an access database from multiple excel files?

0 Answers  

---

How to find out what version of microsoft access I have?

0 Answers  

---

What is the difference between a form and a report in access?

0 Answers  

---

Is access difficult to learn?

0 Answers  

---

What is the main purpose of ms access?

0 Answers  

---