Re: LibreOffice Base?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 




On 5/2/22 09:12, Robert Moskowitz wrote:


On 5/2/22 11:34, Kenneth Marcy wrote:

On 5/2/22 05:12, Robert Moskowitz wrote:


On 5/2/22 08:03, Kenneth Marcy wrote:

On 5/1/22 19:54, Robert Moskowitz wrote:


On 5/1/22 22:01, Dave Stevens wrote:
On Sun, 1 May 2022 21:31:06 -0400
Robert Moskowitz <rgm@xxxxxxxxxxxxxxx> wrote:

I want to create an Access Database on my F35 system so my wife can
also use it on her Windows system using Access.

So I did a quick bit of googling and found that maybe LibreOffice
Base is what I want.

So I did:

dnf install libreoffice-base

which worked, and then tried launching it and

nothing...

Any hints on getting this running?

Yes. You need to install all of LibreOffice so you can achieve interaction between LO Calc and LO Base.

I have, I think, all of LibreOffice installed.  I use Write, Calc, and Impress on a regular basis.  Interesting that Base is not installed when you do your Fedora Install and select to install the LIbreOffice Office suite.


I am under the impression that the standard LibreOffice installation does install all of the modules. When I go to the menu application in this Linux distribution, it lists office as one line item.  Sliding the mouse over that item expands it to a list of many items, the top five of which are LilbreOffice, then LibreOffice Write, Calc, Impress and Draw, in that order. LIbreOffice Base is not listed.  However, if I choose to launch the first item, LibreOffice, without a specific application mentioned, LO opens to show an area of recent documents icons on the right, and a list of six applications, including Math Formulas and Base database, on the left.  Clicking on Base opens a wizard that allows me to either create a new database, open an existing database in this machine, or connect to another database on another machine.  After choosing, for example, to create a new database, another screen appears offering whether or not to register the database with LO, and whether to save the database for editing to create tables using the table wizard. Clicking Finish opens the Base application for work on the open file.

No command lines are involved in this process.

I suggest you check your machine's application menu for a LibreOffice item that does not mention a specific application, then open that to see if the Base application is listed.  If it is, the proceed as above from there.  If it is not, I suggest you update all of LO to the latest version, either from Fedora, or the LibreOffice web site.

I have been running the Xfce desktop for lots of years of using Fedora.  Maybe at least back to Fedora 20.

I have always installed LibreOffice during the base installation. The database component has NEVER been included to the best of my recollection.  There were a couple times I wanted to work with an Access database, and since Base was not installed, I just switched to a Win system.

So I have never used Base for all these years.  Only now trying.

I have never seen Base listed in the Xfce Application selector with LibreOffice installed.  When I go to a running instance of Calc, and <Alt-F> -> New, Base Database is NOT an option.  Like it is just not linked in....

Is this a Xfce/LibreOffice problem?

:(


I would not jump to the conclusion that it is a generic problem with all of LibreOffice and Xfce.  If it were, I think we would have heard about it before now.

However, there may be some unique characteristics of your system's installation of the software.

My first thought is to do a general tidying up of the software by uninstalling, then reinstalling a fresh copy of the latest version of the code.  Of course, before doing any such work, one should make a safe copy of all of the types of files with which LibreOffice is concerned -- documents, spreadsheets, drawings, presentations, etc., to another part of the system's storage structure.  It's a good idea to verify that sufficient storage space is available so no untoward surprises present themselves.

Here is a link to a recent set of instructions about how to go about doing a fresh installation of LibreOffice on Fedora 35.

https://www.linuxcapable.com/install-libreoffice-on-fedora-linux-35/

I include this link because it includes reminders to insure that the system itself is up-to-date, and it features the Flatpak installation process that now seems to be preferred for Fedora systems.  Whichever installation method is used for LibreOffice, it should be an established electronic system method because LibreOffice is a large and complex set of software that it discourages manual installation.




LO Calc has the ability to import and export comma separated files (.CSV) and dBase files (.DBF).

I have done .CSV.


Your wife's Access system can export one of the importable file formats to work in LO Base, and then import from Access through LO Calc in a format that LO Calc is able to import and then provide to LO Base to use.

LO Base does not appear to have the ability to directly import and export the native Access file format, but it can send and receive appropriately formatted table files.

Humph.  This may take rethinking, as I will be expected to 'help' at times, and I can't keep importing and exporting.


Perhaps the rethinking will involve a virtual machine on your hardware within which is running Windows and Access, and appropriate network access between your and your wife's machine.

Might as well just use a Win system.

But what is with Base???


Base is a bit different sort of application because it was never intended to be completely limited to just an individual personal computer.  I has always had in mind the idea of being a "front-end" application to a much larger database engine on a remote machine, so it does not act as if it is totally complete on a personal computer.  It is always looking for a connection to really "big iron," so it assumes that its user will do the extra installation work to make such connections available.

This idea is not unique to LibreOffice Data.  Microsoft Access also has not so secret desires to be mated with larger databases, and to act as a front-end presenter.

Since database files can grow quite large, it is not a bad idea to evaluate the amount of random access memory, hard drive space, and solid state storage available to optimize the operation of whichever combination of database engines and data files are to be placed into service.



Ken

_______________________________________________
users mailing list -- users@xxxxxxxxxxxxxxxxxxxxxxx
To unsubscribe send an email to users-leave@xxxxxxxxxxxxxxxxxxxxxxx
Fedora Code of Conduct: https://docs.fedoraproject.org/en-US/project/code-of-conduct/
List Guidelines: https://fedoraproject.org/wiki/Mailing_list_guidelines
List Archives: https://lists.fedoraproject.org/archives/list/users@xxxxxxxxxxxxxxxxxxxxxxx
Do not reply to spam on the list, report it: https://pagure.io/fedora-infrastructure



[Index of Archives]     [Older Fedora Users]     [Fedora Announce]     [Fedora Package Announce]     [EPEL Announce]     [EPEL Devel]     [Fedora Magazine]     [Fedora Summer Coding]     [Fedora Laptop]     [Fedora Cloud]     [Fedora Advisory Board]     [Fedora Education]     [Fedora Security]     [Fedora Scitech]     [Fedora Robotics]     [Fedora Infrastructure]     [Fedora Websites]     [Anaconda Devel]     [Fedora Devel Java]     [Fedora Desktop]     [Fedora Fonts]     [Fedora Marketing]     [Fedora Management Tools]     [Fedora Mentors]     [Fedora Package Review]     [Fedora R Devel]     [Fedora PHP Devel]     [Kickstart]     [Fedora Music]     [Fedora Packaging]     [Fedora SELinux]     [Fedora Legal]     [Fedora Kernel]     [Fedora OCaml]     [Coolkey]     [Virtualization Tools]     [ET Management Tools]     [Yum Users]     [Yosemite News]     [Gnome Users]     [KDE Users]     [Fedora Art]     [Fedora Docs]     [Fedora Sparc]     [Libvirt Users]     [Fedora ARM]

  Powered by Linux