Opening nsf file in Ms-Access

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.
osmjahirAsked:
Who is Participating?
 
Sjef BosmanGroupware ConsultantCommented:
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
 
Sjef BosmanGroupware ConsultantCommented:
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
 
osmjahirAuthor Commented:
Can you explain me how to get the notes client?
0
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

 
Bozzie4IT ArchitectCommented:
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
 
qwaleteeCommented:
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
 
Bozzie4IT ArchitectCommented:
And you are going the wrong way of course :
You should be migrating your access applications to Notes :-)
0
 
qwaleteeCommented:
Most likely, he should be migrating his application to RDBMS with an app server.

Or, better yes, not migrating at all.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.