cancel
Showing results for 
Search instead for 
Did you mean: 

Lotus Approach

Community Veteran
Posts: 3,826
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
Community Veteran
Posts: 38,460
Thanks: 1,030
Fixes: 62
Registered: 15-06-2007

Re: Lotus Approach

http://support.microsoft.com/kb/302448
It might also be worth trying OpenOffice Base
Moderator
Moderator
Posts: 26,944
Thanks: 1,743
Fixes: 133
Registered: 14-04-2007

Re: Lotus Approach

Or LibreOffice an offshoot of OpenOffice.

Customer and Forum Moderator.

Community Veteran
Posts: 3,826
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
Community Veteran
Posts: 38,460
Thanks: 1,030
Fixes: 62
Registered: 15-06-2007

Re: Lotus Approach

Community Veteran
Posts: 4,868
Thanks: 126
Fixes: 24
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.
Community Veteran
Posts: 3,826
Thanks: 44
Fixes: 1
Registered: 24-09-2008

Re: Lotus Approach

@oldjim:- thanks already read that page.
@RR: Again thanks (twice in one day Roll eyes), 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
Seasoned Pro
Posts: 10,980
Thanks: 265
Fixes: 11
Registered: 01-09-2007

Re: Lotus Approach

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

Community Veteran
Posts: 3,826
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
Community Veteran
Posts: 4,868
Thanks: 126
Fixes: 24
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.
Community Veteran
Posts: 5,169
Thanks: 478
Fixes: 20
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
Community Veteran
Posts: 3,826
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
Community Veteran
Posts: 4,868
Thanks: 126
Fixes: 24
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
Community Veteran
Posts: 38,460
Thanks: 1,030
Fixes: 62
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)