We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

I created a linked database in Base. However it will not allow me to add or create any additional tables. How can I create tables?

asked 2018-07-07 16:47:28 +0200

TomTom gravatar image

The Table creating links are greyed out and it will not allow me to copy a table from another Base file.

edit retag flag offensive close merge delete


@TomTom What do you mean by ...a linked database? Is this linked to a spreadsheet? More info please about your setup.

Ratslinger gravatar imageRatslinger ( 2018-07-07 17:07:15 +0200 )edit

Please be more specific about the linked database, the version of LO and the OS.

Xoristzatziki gravatar imageXoristzatziki ( 2018-07-09 07:36:04 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2018-07-08 06:25:52 +0200

Ratslinger gravatar image


I will guess that the Base file created was done so by connecting to a spreadsheet.

First understand that Base is NOT a database. Base is a front end to data (albeit largely to databases). If you create a new Base file & use the current default you will use the embedded HSQL v1.8 database (LO v6.1 Beta 2 currently defaults to Firebird v3). Otherwise the source of the data is the connection chosen.

With that information, connecting Base to a spreadsheet means all data for that Base file will come from that spreadsheet. You cannot create new tables or copy tables into that Base file. Base doesn't know where in the Calc file to put the table data. If you want something new in that Base file it needs to be added to the Calc file it is linked to.

If you want to use an actual database, you need to take an entirely different approach.

edit flag offensive delete link more


OK Got it. Thanks for your help. I'll take a different approach.

TomTom gravatar imageTomTom ( 2018-07-10 16:32:21 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-07-07 16:47:28 +0200

Seen: 74 times

Last updated: Jul 08 '18