What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

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.


  • Profile Image

    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?

    ms access how how can i can
  • Profile Image
    JotForm Support

    Answered by KadeJM 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:

     https://www.jotform.com/help/245-How-to-Setup-a-Webhook-with-JotForm 

     

    Another option would be to export your data and manually reimport it into your end: 

    https://www.jotform.com/help/374-How-to-export-all-of-your-data-at-once

     

    Lastly, we also have ftp capabilities:

    https://www.jotform.com/help/177-How-to-enable-FTP-on-form-submissions 

  • Profile Image

    Answered by aaronjcody 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?

  • Profile Image
    JotForm Support

    Answered by david 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.