If there any way to display the Lotus Notes Address Book using code, let the user select a name and return the name to Access?
I am using Access97.
I have tried reading the address book into an Access table. This worked but was so slow it will be impractical. The address book will contain approx 40,000 names.
My current workaround is for the user to enter the name in a textbox on an access form. I then query the addressbook for a match. If more than one match is found I am adding just those records to my table and then asking the user to pick one from a linked listbox.
Whilst this approach does work I think it would be more user friendly and less prone to input errors if I could just display the Notes address book directly.
Any ideas or pointers would be most useful.
Thanks in advance.
I am using Access97.
I have tried reading the address book into an Access table. This worked but was so slow it will be impractical. The address book will contain approx 40,000 names.
My current workaround is for the user to enter the name in a textbox on an access form. I then query the addressbook for a match. If more than one match is found I am adding just those records to my table and then asking the user to pick one from a linked listbox.
Whilst this approach does work I think it would be more user friendly and less prone to input errors if I could just display the Notes address book directly.
Any ideas or pointers would be most useful.
Thanks in advance.