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
127 views Asked by CasperMelb At
0
There are 0 answers
Related Questions in MS-ACCESS
- Ctrl+' for copying from previous record in MS Access not working bilingual in Access 2016
- Updating Access Database using C# and stored procedure does not work
- SQL Left Join not including desired rows
- Published MAUI app doesn't work with access database
- Microsoft access sql query to update last record
- Syntax error in FROM clause C# and MSAccess
- sum function in a report
- Excel column datatype issues using MSADO and Access 2016 Engine driver
- Monitor Scaling Issue for Moveable Access Form using MoveWindow win32 API
- ms-access email electronic signiture
- "Make Trusted Document" warning doesn't trigger until exit, causing "Can't exit now" error
- How to compile java gdal PGEO on apple silicon MacOS to read mdb file?
- Access won't open past the splash screen
- Access, Relationship. Too complicated Syntax?
- Table Update from a form using VBA
Related Questions in SHAREPOINT-2010
- how to empty the recycle bin in SharePoint using PowerShell?
- Splitting Child forest from Main forest will impact SharePoint 2013 or 2016 On-premises environment?
- SharePoint Upload Files To Document Library Using Rest API
- Choice radio buttons not updating the sharepoint list
- Is there any option to get this issue resolved as I can only think of OR statement in Edit conditional Formula on sharepoint?
- What is RoleAssignment, RoleDefinition, RoleBinding in Sharepoint On-premise? How to remove a user from the permission list at site level?
- Workflow Error Occurred in SharePoint site
- How to visualize "list progress" in Sharepoint/Teams
- QuickSight Paginated Report Publish to Email Endpoints
- SharePoint CAML Query to Filter Data By Date
- Sharepoint workflow verification
- Way to find modern site is public or private using CSOM
- sharepoint jquery for sum of two column
- Create a flow to move all documents from recycle bin to another library
- How to dowload many files or folders from sharepoint
Related Questions in INFOPATH2010
- using document library or form library
- Sharepoint 2016 Infopath : The trial period for this product has expired
- InfoPath 2010 Error: InfoPath cannot start Microsoft Visual Studio Tools for Applications. InfoPath has encountered the Error. The operation failed
- Count items in Infopath field
- sharepoint list form or form library form
- Non repeating section from repeating section
- How to ensure that the username that is auto-populated does not get replaced by another one in InfoPath
- Info Path cant retrieve SQL data after publishing the form
- install_keras() Error: Keras installation failed (no conda binary found)
- Sharepoint Dropdown Choices Filter
- Infopath 2013 does not point to a valid location path of a field or group
- Infopath ,sharepoint 2013
- Add popup window (html page) in form of infopath
- Setting the 'query field' on an InfoPath Data Connection
- Getting node data from infopath formatted XML
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?
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)