Public InfoPath form connecting to Access db in a restricted location - InfoPath Dev
in

InfoPath Dev

Use our Google Custom Search for best site search results.

Public InfoPath form connecting to Access db in a restricted location

Last post 06-01-2015 06:52 PM by CasperMelb. 0 replies.
Page 1 of 1 (1 items)
Sort Posts: Previous Next
  • 06-01-2015 06:52 PM

    Public InfoPath form connecting to Access db in a restricted location

    Hi, I have used the forums on this site many times to get help but this is the first time I am posting, so, Hi everyone. Hopefully someone has an answer to my question. I have an InfoPath 2010 form which is available to everyone to use, hosted on SharePoint that needs to connect to an Access 2010 database which is stored in a restricted drive location. The form needs to be accessible to all staff but due to the sensitivity of the data being submitted, the database must remain restricted. Also, the form needs to be able to query the database for the secondary data connections. Please note that using SharePoint lists in not an option available to the team that will be maintaining the data submitted. Does anyone know of a way to enable the form to be able to connect to the database to query & submit without assigning access to the restricted folder to all staff. I have been told it may be possible to "assign" a system account to the form which will have access to the restricted folder but I also need to ensure the form can populate the users data into the form ,such as USER() & email address. I would classify myself as a beginner to intermediate InfoPath user. Thank you in advance for any help you can provide. Andrew
Page 1 of 1 (1 items)
Copyright © 2003-2018 Qdabra Software. All rights reserved.
View our Terms of Use.