open access database in libreoffice base

If you created a second Base file, in a separate directory, also named Inventory and selected register it would be named Inventory1.Īnyway - hope that helps clear it up for you.Tedd Hansen Asks: Access multple tenants as Global Administrator with principal from single tenant (PowerShell 7) So if you create a new Base file named Inventory.odb the registered name would be Inventory. If on the other hand you might see yourself doing a mail merge, or wanting to use some of the data in a spreadsheet - then you want to register it.īy default the registered name will be the name of the ODB file it points to. If you are sure you would never need to work with the data in other parts of the office, then perhaps not. When would I register vs not register? If you are working on a one time project - then I would not register the file. NOTE - removing an entry in this dictionary does not delete the file it points to, only the entry in the registration dictionary. This will allow you to register new ODB files directly, change which file a data source name points to or remove a registered data source name.

For example, open a Calc file and hit the F4 key - this opens the data source browser window at the top of the window.įurther you can manage the registration data - which is simply a mapping of a data source name to an ODB file on disk - in the options widow. Wat it is for? Well, if you are in Writer or Calc and you want to import data to a document or produce a mail merge you will be presented with the list of registered data sources.

The data is maintained in the configuration files.

maintains a dictionary of registered data sources per network installation and per user configuration.

Open access database in libreoffice base