I found a cure on an old message board somewhere...
The format structure for the link in Access needs to follow this pattern:
I couldn't get it to work with a screen tip at the end so left it off and it works. In the Access cell it simply says "Link" but takes me to the full address of the exact document I need.
I understand the "Link" in the middle of the string can be anything but could be used if you have a specific view you want to look at the document in. I don't need it and have not tried leaving it out altogether.
So...I export my list from Notes to Excel, concatenate the link into a cell as shown and import to Access.
Thanks for all your help. I always learn something out of these communications.
This can be done a few ways, but the easiest is likely the Notes URL. Very similar to a web URL except it starts with notes:// instead of http://. The server reference sometimes needs to be different as well, depending on your corporate DNS. For example, sometimes notes://server.domain.com/database/0/documentunid?opendocument will work, but other times it will be just notes://server/database/0/documentunid?opendocument.
Another way is to capture the “Doc Link” info into an NDL file and just add the NDL file into the ACCESS database. If a user launches the NDL file it will work like a doc/view/db link.
NDL files are just text files formatted a specific way and saved with an extension of .NDL.