- aaronjcodyAsked on July 19, 2016 at 12:17 PM
I am trying to create a form that automatically (but securely) sends the submissions to an access database.
How do you recommend sending this data to MS Access while keeping it secure rather than publishing to the web?
- KadeJMAnswered on July 19, 2016 at 01:15 PM
To my understanding it seems to me that you wish to send your form submission data to your external ms access database.
If your database supports mysql and php you could export it there as mentioned in this guide here: https://www.jotform.com/help/126-How-to-send-Submissions-to-Your-MySQL-Database-Using-PHP
Alternatively, it is also possible to send data there using a webhook:
Another option would be to export your data and manually reimport it into your end:
Lastly, we also have ftp capabilities:
- aaronjcodyAnswered on July 19, 2016 at 02:02 PM
Which of these options would provide the most security when transferring private information between JotForm and Access?
- JotForm SupportdavidAnswered on July 19, 2016 at 02:44 PM
All of the methods are secure. Webhooks and using PHP both support SSL and are very secure. Exporting your data manually to Excel format and importing it manually to your database would give you complete control over the transfer.