Send form data to database with scripted button

[DKinsley]

I know how to connect the form to an Access database. However, I do not want the form to connect to the database until the user clicks a button. When the user completes the form and clicks the button, I need the form to connect to the database and save the form data as a new record. How do I script the button to do this?

Any help is appreciated.

[yvindevogel · Accepted solution]

I think you will need to use a layer in between.  For instance with LC, you can make a process that takes in your data and stores it in your database.  Your form can submit to that process through SOAP and REST.