This entire episode is frustrating. Hopefully some kind person will have a solution for this.
First, there seems to be no way to import an entire spreadsheet and have it make each tab into its own table. (Okay, whatever.)
Second, after copy and pasting 20 tables manually into BASE, I save it then immediately go to save it again with another name (for redundancy / backups). It gave a quick error about connecting to (the original name) database, and the whole thing crashes. (Why would it need to connect to anything? I manually entered everything in!?)
Third, upon re-opening it won’t open either file. The original file gives an error that says “The database is already in use by another process” and the new-name file says “The driver class ‘’ could not be loaded.”
What in the world happened? All I did was save the file (successfully?) and then ATTEMPT to save it under a new name. Why EVER would this not only break LO Base, but also break both files??
Fourth, searching for an answer in these forums has been futile. Many people have asked the same question. No real answers have been posted (that I saw).
PLEASE, does anyone know how to get my data back? And if I have to spend a half-hour re-doing it all, what guarantee (lol) is there that the same thing won’t happen again? What I mean is, I didn’t think it should have broke at all. (???) Other people have also had this problem so I’m concerned enough to post here before just re-doing it all.
BTW, I last updated LO a month or so ago. It’s v 126.96.36.199 running on Windows.