cancel
Showing results for 
Search instead for 
Did you mean: 

Lotus Approach

journeys
Aspiring Pro
Posts: 3,829
Thanks: 44
Fixes: 1
Registered: ‎24-09-2008

Lotus Approach

I've been given some historic data that was written and backed up with Lotus Approach, there are around 10,000 records in a database.
Has anyone any idea what software would currently read them
TIA
13 REPLIES 13
Oldjim
Resting Legend
Posts: 38,460
Thanks: 787
Fixes: 63
Registered: ‎15-06-2007

Re: Lotus Approach

http://support.microsoft.com/kb/302448
It might also be worth trying OpenOffice Base
Strat
Community Veteran
Posts: 31,320
Thanks: 1,609
Fixes: 565
Registered: ‎14-04-2007

Re: Lotus Approach

Or LibreOffice an offshoot of OpenOffice.
Windows 10 Firefox 109.0 (64-bit)
To argue with someone who has renounced the use of reason is like administering medicine to the dead - Thomas Paine
journeys
Aspiring Pro
Posts: 3,829
Thanks: 44
Fixes: 1
Registered: ‎24-09-2008

Re: Lotus Approach

@strat, @oldjim:-  thanks, not much help I'm afraid, all I have is a 500k .APR file. I've tried access, base, calc, xl, as import, connect and open, also tried importing with SQL server, no luck. Guess I need to get onto the original PC that housed the Data. Undecided
Oldjim
Resting Legend
Posts: 38,460
Thanks: 787
Fixes: 63
Registered: ‎15-06-2007

Re: Lotus Approach

ReedRichards
Seasoned Pro
Posts: 4,927
Thanks: 145
Fixes: 25
Registered: ‎14-07-2009

Re: Lotus Approach

Sometimes a two-stage approach pays off (although not in this case, judging by the link Oldjim just found).  It is more likely that a contemporary rival of Lotus Approach might have the ability to import its files than the modern equivalent.  So perhaps Access 2000 could, whereas modern Access cannot.  But modern Access could read an Access 2000 file.
journeys
Aspiring Pro
Posts: 3,829
Thanks: 44
Fixes: 1
Registered: ‎24-09-2008

Re: Lotus Approach

@oldjim:- thanks already read that page.
@RR: Again thanks (twice in one day ::)), have office 97 thru office 2007 installed on different PC's, no luck.
But I have found the original PC, now to try and get access to it.
VileReynard
Hero
Posts: 12,616
Thanks: 582
Fixes: 20
Registered: ‎01-09-2007

Re: Lotus Approach

If there is any connection with Lotus Notes, you're stuffed. Cheesy
It may be encrypted....

"In The Beginning Was The Word, And The Word Was Aardvark."

journeys
Aspiring Pro
Posts: 3,829
Thanks: 44
Fixes: 1
Registered: ‎24-09-2008

Re: Lotus Approach

Foxy:- thanks guess I came to that conclusion.
why-oh-why do folk backup the data then forget to keep copies of the program that created it. Crazy
ReedRichards
Seasoned Pro
Posts: 4,927
Thanks: 145
Fixes: 25
Registered: ‎14-07-2009

Re: Lotus Approach

But see http://en.wikipedia.org/wiki/IBM_Lotus_Approach .  Lotus bought Approach from a company of the same name so any relationship with Notes may be in name only.
ejs
Aspiring Hero
Posts: 5,442
Thanks: 631
Fixes: 25
Registered: ‎10-06-2010

Re: Lotus Approach

This implies you don't even have the data if all you have is just a .apr file, there should be a .dbf file with it:
http://www-01.ibm.com/support/docview.wss?rs=0&uid=swg21172044
journeys
Aspiring Pro
Posts: 3,829
Thanks: 44
Fixes: 1
Registered: ‎24-09-2008

Re: Lotus Approach

@ejs:- you could well be right. It is a "backed up" file from around 2002, although would be surprised that a 'national organisation' didn't test their backup process Undecided
ReedRichards
Seasoned Pro
Posts: 4,927
Thanks: 145
Fixes: 25
Registered: ‎14-07-2009

Re: Lotus Approach

Quote from: journeys
would be surprised that a 'national organisation' didn't test their backup process

You would??!?Huh
Oldjim
Resting Legend
Posts: 38,460
Thanks: 787
Fixes: 63
Registered: ‎15-06-2007

Re: Lotus Approach

When my previous employer moved offices from Poole to Sheffield (they closed the Poole office) they backed up all the CAD files using the system built in archiving system.
All good you would think
Unfortunately the database system used for CAD storage and document control in the Poole office was unique to that office and when they closed the office they scrapped the system without having checked whether the Sheffield system could access the files.
Guess what - they now had all the CAD files carefully backed up and transferred to Sheffield but they couldn't access any of them.
Of course it didn't help that as part of the office closure they made the entire IT department redundant (I wonder if they hadn't done that there error would have been pointed out and the CAD files extracted from the database into a more normal storage system)