Ask Your Question
0

Load new tables from MySQL database into existing Base front end

asked 2018-10-04 06:13:02 +0200

Tonyb gravatar image

I have an existing LibreOffice base file which has a data source of a MySQL database. The current file is working correctly but I have just added 3 new tables to the MySQL database. How do I get the existing base file to recognise these new tables?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2018-10-04 06:32:14 +0200

Ratslinger gravatar image

Hello,

Typically if they are in the same schema Base will recognize them.

If they are not seen, then on the main screen of the .odb, from menu select Tools->Table Filter.... On the ensuing dialog, find your tables in the list and make sure the box to left of table is checked. Close the dialog. Then select the Tables section (Database column on left) and then from menu select View->Refresh Tables. This will regenerate the list of tables and your newly created tables should be there.

edit flag offensive delete link more

Comments

Thank you once again for the quick reply with the correct answer. I did do a search in the LibreOffice help files for Refresh Tables and the only mention referred to Calc - Pivot tables Similar for the "Table Filter" option referred to Pivot Tables

Tonyb gravatar imageTonyb ( 2018-10-04 07:09:17 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2018-10-04 06:13:02 +0200

Seen: 59 times

Last updated: Oct 04 '18