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(a)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