** Forwarding message from Ernest Dale <ernest.dal...@gmail.com> on Tue, 21 Jan 2014 13:28:22 +0000
Thanks to everyone who has taken interest in my problem Having now got Approach to work I am sticking with it. My new problem is how to deal with the influx of help from well-wishers! Ernest On 21 January 2014 04:24, Cliff Scott <c...@intergate.com> wrote: > ** Reply to message from Alex Thurgood <alex.thurg...@gmail.com> on Mon, > 20 > Jan 2014 09:19:13 +0100 > > > Le 19/01/2014 16:02, Tom Davies a écrit : > > > > Tom, > > > > > Can Base directly connect to a Lotus Approach database and use it as > > > the back-end? > > > > 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. > > Alex, > > Slight correction, Approach was written for OS/2 Warp4 as well as Windoz. I > am using ver 1.6 on eCS running in VBox on my Mac. As you say it is very > intuitive and easy to make queries. I would change over to Base if it was > straight forward, but there's no way Base would be anywhere near as easy to > use so I'm sticking to eCS. > > Cliff > > -- > To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org > Problems? > http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette > List archive: http://listarchives.libreoffice.org/global/users/ > All messages sent to this list will be publicly archived and cannot be > deleted > > -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted