NathanBurley
Registered User.
- Local time
- Today, 22:22
- Joined
- Jul 28, 2015
- Messages
- 19
Hi Folks,
I want to allow users of my Access WebApp to upload files to our SharePoint site and then place a link to that file's location from within the app.
To migrate existing data, I've uploaded all the files and I've created a table from the SharePoint list, importing the file names (a hyperlink) in this table to my desired Webapp table. This works great, however, it's not very easy for end users to continue this practice. I'd like to keep the document list as a Linked Table so that when they upload a new file to SharePoint, the linked table updates. I can then use a macro to match records in an Access Table with the records in the Linked Table and voila it should automatically add the link....
...the sticking point is that I can't use macros to even read from a Linked table. So, I'm wondering what the point of linked tables even is?
If I can't do it this way, is there a way anyone can think of that I can have users manually add a file to SharePoint and then click a button in Access to browse for the correct file, before having that file's hyperlink added to the current record? ...because I'm stuck again.
Thanks,
N
I want to allow users of my Access WebApp to upload files to our SharePoint site and then place a link to that file's location from within the app.
To migrate existing data, I've uploaded all the files and I've created a table from the SharePoint list, importing the file names (a hyperlink) in this table to my desired Webapp table. This works great, however, it's not very easy for end users to continue this practice. I'd like to keep the document list as a Linked Table so that when they upload a new file to SharePoint, the linked table updates. I can then use a macro to match records in an Access Table with the records in the Linked Table and voila it should automatically add the link....
...the sticking point is that I can't use macros to even read from a Linked table. So, I'm wondering what the point of linked tables even is?
If I can't do it this way, is there a way anyone can think of that I can have users manually add a file to SharePoint and then click a button in Access to browse for the correct file, before having that file's hyperlink added to the current record? ...because I'm stuck again.
Thanks,
N
