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 <r...@htt-consult.com> 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@lists.fedoraproject.org
To unsubscribe send an email to users-le...@lists.fedoraproject.org
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@lists.fedoraproject.org
Do not reply to spam on the list, report it:
https://pagure.io/fedora-infrastructure
