I’m using Libreoffice 7.4.5 on Fedora. I created a database by connecting to an .ods file. Created forms and reports that were working properly.
Today I opened it again to continue working on it, but the name of the table changed by adding a “Original name (1)” at the end. All forms and reports I had created started giving errors "There exists no table named "Original name ". 
What can I do?
A *.odb-file, connected to a Calc-files, only reads the tables of the Calc-file. Rename the table in the Calc file.
1 Like
A database-like table on a spreadsheet has a single row of column labels and distinct column types (numbers, dates, times, text) below the labels.
Base interpretes the used area of each sheet as a “table” which includes some sheets having some data not shaped like a table or where multiple areas are used in addition to some table or sheets having more than one table.
In addition to the concept of “used areas” you can define database ranges via menu:Data>Define… Base interpretes these ranges as database tables as well. These ranges expand as you insert new cells before data entry.
In Base there is a table filter which allows to hide tables which are not meant to be tables.