Le 19/01/2014 16:02, Tom Davies a écrit :
Can Base directly connect to a Lotus Approach database and use it as
No. Never has and probably never will.
@Ernest, Have you still got access to the old Windows and thus the
Lotus Approach directly or was this an upgrade (or a machine exchange
or some sort)? I take it you exported the data as a ".csv" file and
that is what is looking like a flat spreadsheet?
Lotus Approach saves its databases as an APR file extension, but the
actual data is stored as a group of DBF tables. Any binary (e.g. image)
data or extended character data (Memo fields, etc) are stored in a
separate DBT file which is referenced in some way by the APR file and
thus appears in the DBF file that contains the binary field.
It was/is for its time a brilliant piece of kit that held its own with
Access and FMPro. It had an accessible UI and form builder, had a fairly
competent SQL parser, and could even be scripted with Lotus Smartscript.
In fact, from the user perspective, it was "intuitive", everything which
LO Base is not. I fully understand why people have stuck with it.
However, it was essentially, single OS (well it did run on OS/2 as well
for a while in Windows compatibility mode), as the software was provided
for the Windows platform only.
Impressum (Legal Info)
: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (MPLv2
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our trademark policy