"This table name is not valid in the current database" Libre Office Base

[ocgirl]

I am not importing data from another source. This is a simple copy from LO Base file into another.
Books.LIbreOffice.org doesn’t have a 7.4 ver., but 7.3 Appendix A, says that you can copy & paste, "Forms, Queries and Reports, " (no mention of tables). Then it moves on to the recovery of a data base file. There are no notes about error messages.

This post from Ratslinger has the error codes for HSQLBD. Thank you so much for posting this. Error Code:-78 - #2 by Ratslinger
I did a search of the file and did not find anything about a table name validity.

I am not merging database files, or tables. Is this what I should do if copy & paste don’t work?
I did not find info on merging from one LO Base file to another. Only from some other DB to LO in help.openoffice.org, and help.libreoffice.org (ver. 6.1) The Sheepdog Guides and Thefrugalcomputerguy.com have tutorial about exporting from DB to Calc but not DB to DB. My DB is registered but when I click new, but I hesitated because it wanted me to create a new DB. I want to copy Tables, Forms, and Queries from one existing DB to another existing DB.

I could not find anything in the Hyper HSQLDB Guide. The original had the name Table in it, so I changed it to tbl and I got the same not valid error. I had just copied this Table from an oldold.Copy.odb to an old.Copy.odb and it worked. Then I tried to copy it into the DB I was working on & it failed. Could it be a memory or a Cache problem? Ver 7.4.5.1 Win 11.

[robleyd]

It isn’t clear exactly how you are trying to “copy”, which I suspect means import, from the source database. Can you describe exactly what you did, and provide the full text of the error message.

[RobertG]

@ocgirl

Appendix A, says that you can copy & paste, "Forms, Queries and Reports

Without tables the database couldn’t work. So it isn’t mentioned in “Appendix A”.
If you are copying queries, forms, reports and macro code from one database file to another you will also need the same table structure.

Please write exactly:
Which database (HSQLDB, Firebird, external database …) do you want to use.
Which table name will produce the error?

I won’t use any special character in table names. Only normal characters, _ and also all numbers. No spaces and other signs.

[ocgirl]

I had a current file I was working on opened. Then, I opened the old file. I highlighted the table I wanted to copy, in the old file, and right clicked - copy. Then I moved back to the current file Tables page, clicked a blank part of the page, beneath my other tables and right clicked paste. I also tried Ctl C and Ctl V.

The Full text of the message is “This table name is not valid in the current database”

[ocgirl]

I am using Libre Office 7.4.5.1 to Libre Office 7.4.5.1.

[RobertG]

You try to Append data (see the dialog in the background) to a table “SeedOtherCost”. How could you append data to a table, which isn’t table of the database. Switch to Definition and data and the table will be created.

But: With LO 7.4.5.1 you will get the bug described here.

[ocgirl]

Please see topic from previous night

7.4.5.1 Base Table Copy Paste to Another Open Base File

An error occurred. Do you want to continue copying? What are the possible reasons a working table would cause this error. I am not changing anything. The fields and field types are all the same. The table works in the original database. I have tried removing the primary key, and changing all fields to NO for required entry. It creates the tables with the column titles, but the data is not copied. LO crashed earlier. I have been having problems copying for hours. At one point the copy, …

[Villeroy]

Either you choose “Append data”. Then you need the name of an existing table.
Or you choose one of the other options. Then you need a table name that does not exist yet.
You have chosen to append data to a table that does not exist.
“Definition and data” copies the table with contained data.
“Definition only” copies the table structure with no data.