Lawrence Mrazek
lmrazek at lcm-res.com
Wed Sep 15 11:48:57 CDT 2010
Just tried linking to a Sharepoint list ... this might be the method I can use to maintain the document linkages ... Larry Mrazek lmrazek at lcm-res.com ph. 314-496-1645 -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Hewson Sent: Wednesday, September 15, 2010 11:24 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Link to Document in Sharepoint Libraray Here are a couple of things to keep in mind. IF you are using AD with SharePoint it is possible. However, keep in mind if the user does not have access to the SharePoint site then they will not be able to link to the library. Each library has its own URL, so the link is essentially a hyperlink. If your location is the document library and the user has access rights then browsing would be allowed. If not the user will get a message that they are not authorized to that site. A person could select a file, and then save the URL to a field in Access if needed. I'm not sure that's the way I would go. I would be more inclined to give them the URL to the document library only - sometimes the URL changes if the document changes. I would bypass Access entirely. Jim -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Lawrence Mrazek Sent: Wednesday, September 15, 2010 10:39 AM To: 'Access Developers discussion and problem solving' Subject: [AccessD] Link to Document in Sharepoint Libraray Hi Folks: I have an application that currently links to documents on a fileshare ... this has worked well, but now it looks like we're going to convert all of their document management to Sharepoint. While I have some experience with Sharepoint, I'm not sure if it is possible to do the following: 1. Browse a sharepoint document library 2. Select a file, save the file location to access. Does anyone have any experience with this? Is it even possible? Larry Mrazek lmrazek at lcm-res.com ph. 314-496-1645 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com