JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.
How can I send private data to MS Access automatically?Asked by aaronjcody 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?
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:
Which of these options would provide the most security when transferring private information between JotForm and Access?
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.