Solved

Opening nsf file in Ms-Access

Posted on 2004-08-03
10
1,541 Views
Last Modified: 2013-11-16
The small application which implemented lotus domino file (nsf file), I need to convert it to ms-access, so can any one help me how to see the domino database  (nsf file) in Ms-access 2000. Actually I don't know anything about Lotus Domino designer.
0
Comment
Question by:osmjahir
  • 2
  • 2
  • 2
  • +1
10 Comments
 
LVL 46

Expert Comment

by:Sjef Bosman
ID: 11703467
Get a Notes client somewhere, and export the data. Or use Lotus Approach, also capable of reading .nsf files. These are the only two ways!
0
 

Author Comment

by:osmjahir
ID: 11711653
Can you explain me how to get the notes client?
0
 
LVL 46

Accepted Solution

by:
Sjef Bosman earned 20 total points
ID: 11712984
There are several ways:
- find a company nearby that sells Lotus Notes
- try to download it from the IBM-site somewhere (you can get a 90 days trial version, I think), see http://www-10.lotus.com/ldd/down.nsf

If I may be so bold to ask you: where did you get the .nsf file, if you don't have Notes? And how do you know the application? Note that it might even be difficult to open the database, because you usually need a Notes-ID to get in.

You need a Notes-client to be able to export the data, and a Domino Designer to inspect the design of the application.
0
ScreenConnect 6.0 Free Trial

At ScreenConnect, partner feedback doesn't fall on deaf ears. We collected partner suggestions off of their virtual wish list and transformed them into one game-changing release: ScreenConnect 6.0. Explore all of the extras and enhancements for yourself!

 
LVL 15

Expert Comment

by:Bozzie4
ID: 11714911
Download the Notes client, and download the ODBC driver for Lotus Notes.  You can now create an odbc datasource to connect to the notes database, but you will still need a notes id !

cheers,

Tom
0
 
LVL 31

Expert Comment

by:qwaletee
ID: 11727707
SO far you are getting advice on how to techincally connect and get access to the data.  An important consideration, and possible a tougher problem, will be the data structure.  Notes is non-relational, and does even use a homogeneous flat file structure.  There is also a tendency among Notes programmers to use data fields for working values, that then get saved with each record (document).  The view structure is most akin to a relational database, but contains a subset of the rows and columns that you might have to translate to.  So, you are probably going to need to deconstruct the Notes database into the core elemnts that need to be exported to Access, and then design a data model to suit.

Of the options given so far, the one most likely to work well for you is Notes client + the NotesSQL ODBC driver.  You can then pull out data by FORM (not by view), and possibly get enough information to do a quick load into Access.
0
 
LVL 15

Expert Comment

by:Bozzie4
ID: 11727898
And you are going the wrong way of course :
You should be migrating your access applications to Notes :-)
0
 
LVL 31

Expert Comment

by:qwaletee
ID: 11738760
Most likely, he should be migrating his application to RDBMS with an app server.

Or, better yes, not migrating at all.
0

Featured Post

Does Powershell have you tied up in knots?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This is an old article, please see an updated version of this article, located here: http://www.experts-exchange.com/articles/23619/Notes-8-5x-Windows-7-Notes-info-and-tips.html
Notes Document Link used by IBM Notes is a link file which aids in the sharing of links to documents in email and webpages. The posts describe the importance and steps to create a Lotus Notes NDL file in brief.
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

821 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question