I just solved an issue after about a week of headaches: I had an Access 97 database which I could not open with anything (Access 2007, Excel 16 importing, etc). It would say "The operation is invalid without a current index" or "The current user account doesn't have permission to convert or enable this database." I would find out using a recovery program that this database did not have any set users in its security, which is bizarre.
I solved the problem from a 2003 post in this thread. I opened Excel 16, opened the Data tab, selected "From Other Sources", selected "From Microsoft Query", chose "New Data Source", supplied a name of my choosing, chose Microsoft Access Driver (*.mdb), and hit the "Connect" button.
A dialog opens where you can choose the MDB file. It also has another button, "Repair". If I hit "Repair" when selecting my problematic database, it then will work with any application without throwing either of the errors I was getting.
What I want to know is how to use this "Repair" function from the command line, if possible. I will need to include operations on this database as part of a batch file with 40 other databases that were not giving me any errors.
Is this possible?