sharepoint forum?

[Isaac]

Is there any forum on this site where it might be appropriate to post a Sharepoint question? like designing a sharepoint form in infopath? Or is there another good active site for that?

 

[vba_php]

you might have luck here, even though it's not technically a sharepoint forum. SP is an MS product, thus the people over there might be of help:

Microsoft Community

furthermore, this place here should be the place for you too:

Other Software

Discuss your other software issues here

www.access-programmers.co.uk

 

[Pat Hartman]

I thought InfoPath was discontinued years ago. Is it back?

 

[theDBguy]

I thought InfoPath was discontinued years ago. Is it back?

I don't think so. The last version of InfoPath was 2013. After that, MS started pushing PowerApps. However, if you had old InfoPath forms, I think they still work in SharePoint 2016 or O365.

 

[Isaac]

Now c'mon guys, don't make me feel like an antiquated grandfather LOL! I am sure there are plenty of people still using something from 2010 (sharepoint) and 2013 (infopath). Judging from the # of people still on Office 2010, or maintaining vb6 apps, these things don't just go away.
Sharepoint 2010 works just fine with Infopath2013, and still comes with the "Customize in Infopath" button, which opens Designer 2013.

Not everyone upgrades to the newest software right away. I am stuck with this at my current company.

 

[Pat Hartman]

I really liked the idea of InfoPath and as soon as I found an app to use it for, I discovered it was going to be discontinued the following year. So, I never used it but good luck.

 

[Isaac]

thanks Pat. I did find one dev forum site, that may help.

 

[NauticalGent]

InfoPath worked too well - simply cant have THAT!!

 

[mindeatn]

https://www.infopathdev.com/ is an excellent site. I have a client that likes InfoPath. I still build new forms for them on occasion.

 

[tmaccabe]

Sure feels like there are enough people linking to SharePoint Lists (and soon to DataVerse For Teams) that a SharePoint Backends forum/thread should be a thing. There are lots of lessons-learned we could share/browse.

 

[NauticalGent]

Check out this link. Probably the most complete and informative source for Access and SharePoint out there.

 

[Smiley 3636]

Hi I understand, the reasons, not to run the access database from other sources, other than your desktop as has been clearly pointed out. But what Id like to achieve, is to use Microsoft access to view uploaded documents like PDF files, on to SharePoint, as well as Excel and Word files. And to also to mail merge with the Excel, along with word files, and save these files to another folder. Preferably to a folder that Ive designated for as client information, while able to view a list of stored documents associated with the clients folder. At present, there are two users with their own separate Microsoft Access office 365 running on the machines, who would access to the templates. I do not wish to have these templates altered unless I altered them myself, or the other user does. As I dont want the clients file that the template would be eventually saved to with extra documentation information to be corrupted if both are trying to use it at the same time. Is there a way of preventing two users opening the same document at the same time? If so, how? I would also like to know if I can use Microsoft Access to make new folders or list of folders on SharePoint? The idea of using SharePoint as the name suggests, is so both can users can view and use the one type of information and have an access to it, using Microsoft Access on each individual desktop. It is possible to be achieved this out come? Which one of your courses would help me to achieve this and can I get a copy or do I have access even after I pay for it later on down the track? The reason I ask that is because I do not have the experience or knowledge you have accumulate over the, years. due to fact Im getting older and have different career, and feel that I would need to refer to it now and then. The idea is to have a directory with templates of word and Excel files in which I can view on Microsoft Access using list view! If thats possible, and use those templates to do a mail merge and save them on another folder within SharePoint, e.g. clients folder to which I store the file, and with ability to email through to Outlook. Is this possible?

 

[GPGeorge]

Sure feels like there are enough people linking to SharePoint Lists (and soon to DataVerse For Teams) that a SharePoint Backends forum/thread should be a thing. There are lots of lessons-learned we could share/browse.

Beware of jumping on the Dataverse bandwagon for Access. All I'm saying is make sure you know what you're getting into. In m experience, DV tables are not as performant as, oh say, Azure SQL or SQL Server or even SharePoint lists.

They do offer one advantage. When used with PowerApps, they can be configured to support off-line synching. I.e. lose you your internet connection and PowerApps caches data on the device running that app pending a reconnect to the internet. I don't think that's supported yet when linked to Access, though.

Just be aware of what you are getting into before committing to Dataverse as your backend.

 

[theDBguy]

@Smiley 3636 Welcome to AWF!

I don't understand why you need Access. Access is used to link to SP Lists. I'm not sure if you can use it to link to Document Libraries.

 

[Isaac]

@Smiley 3636 Welcome to AWF!

I don't understand why you need Access. Access is used to link to SP Lists. I'm not sure if you can use it to link to Document Libraries.

You can mount the document libraries as a mapped drive with credentials and then dump files in there in some cases depending on the company SharePoint setup

 

[Isaac]

You can mount the document libraries as a mapped drive with credentials and then dump files in there in some cases depending on the company SharePoint setup

Some setups even allow for a UNC folder path for document libraries

 

[theDBguy]

You can mount the document libraries as a mapped drive with credentials and then dump files in there in some cases depending on the company SharePoint setup

So where does Access come into play in there? Just curious...

 

[tmaccabe]

Hi I understand, the reasons, not to run the access database from other sources, other than your desktop as has been clearly pointed out. But what Id like to achieve, is to use Microsoft access to view uploaded documents like PDF files, on to SharePoint, as well as Excel and Word files. And to also to mail merge with the Excel, along with word files, and save these files to another folder. Preferably to a folder that Ive designated for as client information, while able to view a list of stored documents associated with the clients folder. At present, there are two users with their own separate Microsoft Access office 365 running on the machines, who would access to the templates. I do not wish to have these templates altered unless I altered them myself, or the other user does. As I dont want the clients file that the template would be eventually saved to with extra documentation information to be corrupted if both are trying to use it at the same time. Is there a way of preventing two users opening the same document at the same time? If so, how? I would also like to know if I can use Microsoft Access to make new folders or list of folders on SharePoint? The idea of using SharePoint as the name suggests, is so both can users can view and use the one type of information and have an access to it, using Microsoft Access on each individual desktop. It is possible to be achieved this out come? Which one of your courses would help me to achieve this and can I get a copy or do I have access even after I pay for it later on down the track? The reason I ask that is because I do not have the experience or knowledge you have accumulate over the, years. due to fact Im getting older and have different career, and feel that I would need to refer to it now and then. The idea is to have a directory with templates of word and Excel files in which I can view on Microsoft Access using list view! If thats possible, and use those templates to do a mail merge and save them on another folder within SharePoint, e.g. clients folder to which I store the file, and with ability to email through to Outlook. Is this possible?

My experience linking Access to a Document Library is that I couldn't update the libary without error. I could read it just fine, but not write to it. I haven't tried using VBA to edit a Document Library. Perhaps if it's sync'd to OneDrive you could use the File System Object? No idea. Didn't think to try it. I had a bunch of stuff in Access I wanted to convert to a Document Library: Folders, Document Sets, and Files (all with metadata). I ended up exporting the data to Excel and then building a Power Automate flow to read the worksheet's table and setup/fill the library.

 

[tmaccabe]

Not sure why the site wouldn't let me post this reply? Bad content or spam-like? I don't see it. How to avoid? Maybe that's a question for another thread. This one is about having a forum for SharePoint as it relates to Access, correct?

 

[NauticalGent]

Not sure why the site wouldn't let me post this reply?

Your reply contained a link (even though it was mine) and noobs cant post links until they have 10+ posts...