Problem solve Get help with specific problems with your technologies, process and projects.

Best practices to synchronize a Notes DB and MS Access

How can I best synchronize a Notes DB and MS Access data? I would like to synchronize only in the morning in one direction and in the evening in the other. Could you help me please?
Lotus Enterprise Integrator (LEI) -- read about it here. Create two replication activities -- one to migrate data from Access (using the ODBC or OLE DB connector) to Notes, and one to go the other way. Schedule them to run daily at the appropriate times. Use Order metaconnectors on both sides to make sure the Notes data are sorted (this shouldn't be necessary but apparently is in current versions; we're investigating).

You could of course program the same operation using the LC LSX and make it a couple of scheduled agents. LEI just makes it easier. Refer to What's wrong with my code?? for a description of the basic replication algorithm.

Dig Deeper on LEI and DECS for Lotus Notes Domino

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.




  • iSeries tutorials

    Search400.com's tutorials provide in-depth information on the iSeries. Our iSeries tutorials address areas you need to know about...

  • V6R1 upgrade planning checklist

    When upgrading to V6R1, make sure your software will be supported, your programs will function and the correct PTFs have been ...

  • Connecting multiple iSeries systems through DDM

    Working with databases over multiple iSeries systems can be simple when remotely connecting logical partitions with distributed ...