I have searched 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 certain fields ,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
Publicly available InfoPath form connecting to Access db in a restricted location
117 Views Asked by CasperMelb At
0
There are 0 best solutions below
Related Questions in MS-ACCESS
- Joining date fields from 2 separate tables in Access 2010. Outer join is acting like an inner join
- Access Global not working
- Dividing summed field by another summed field in the same query
- Edit fields in local table linked to PassThrough Query
- Change Index Settings Access VBA
- On click change chart query in ms access
- Access 2013 - Set a field value based on value of another field
- MS Access, Combobox, select fields bases on query, How do I weight the result fields
- Access SQL: Not Equals on Null Text Field
- MS Access If Function
- How to convert MS Access Database to Mysql with french characters
- MS Access: How to group by first column- summing some columns while keeping others the same
- Using an ODBC connection in Access get retrieve data from DB2
- How to Continuously Develop and Deploy an Access 2010 Database Application
- Adding calendar in ms access and view the data of specific day by clicking the date
Related Questions in SHAREPOINT-2010
- Upload a document to a SharePoint document library (can be via Rest Api/other) using C# & also retrieve the unique id of the document
- Sharepoint alers email deletion from alerts
- Apache Reverse Proxy erases <meta http-equiv="Content-type" content="text/html; charset=utf-8" />
- Can REST-like URLs be passed/recognized in sharepoint 2010?
- Configure SharePoint 2010 UPS with PowerShell
- How to dynamically create Sharepoint ComboBoxes?
- SharePoint 2013 Custom list field iterator not saving values for MultiLine or person columns
- Publicly available InfoPath form connecting to Access db in a restricted location
- Why does my Sharepoint WebPart deploy (nominally), but is still not available for adding to a page/form?
- Does CAML Query has a default RowLimit value?
- SharePoint CSOM
- I am getting a The type or namespace name 'listcolumns' could not be found (are you missing a using directive or an assembly reference?)
- Sharepoint 2010 CMIS Integration
- JQuery Show All Tab - Issue with on click
- jQuery UI API failing to load properly with LABjs
Related Questions in INFOPATH2010
- Publicly available InfoPath form connecting to Access db in a restricted location
- Removing Formatting from Text Box Controls - InfoPath
- How to Query Large Sharepoint 2013 Lists in Infopath 2010?
- SharePoint 2010 In-Browser Form User Info Changing after Submit
- Sharepoint - Load a form's view based on user
- How to programmatically do math operations on two fields of type "Time" in Infopath
- InfoPath Form in SharePoint
- how to display the infopath dropdown based on the yes/no value in the sharepoint list - Infopath, sharepoint 2010?
- Operation is not valid, because of the current state of the object
- InfoPath 2010 getting sum for option button
- encoding HTML issues inside xml tag xmltextwriter
- Accessing inner text from XML in C#
- InfoPath 2010: Trouble programmatically adding rows to a repeating table/section that is nested within a repeating table
- Multiple Cascading Dropdowns - Infopath Form from SharePoint List
- file attachment option required in infopath 2010 for forms created from sharepoint list
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?