Add data via WP site to database

  • Hi,
    I am asking for advise for the following.
    I have a website running standard WP. I would like here to publish form protected by password where assigned persons can enter information. This form needs to be connected to a table. And this table must be linkable to ms access database running on the admin machine from where the website is controlled and edited. If possible Sharepoint service should be avoided but not on every price.
    thank you

Viewing 2 replies - 1 through 2 (of 2 total)

  • You can publish this form on a page that is either protected by a password. Or you can publish a “Private” page that will be visible only to logged-in users. (The password a visitor enters for a password-protected page is saved to a cookie, so next time the user comes back, they may be able to see the page content immediately without entering the password again.) Both these options are native to WordPress.

    There are form plugins that save the input data to the WordPress database. “Caldera” (I believe).
    There are some free add-ons for “Contact Form 7” that can save submitted data to the WordPress database.
    But I’m sure there are more.

    The tricky part is “importing to MS Access”. If we’re talking about a locally stored Access database, then you may need to find a way to manually import the data, perhaps in CSV format.
    If the database is stored on some server and is available 24/7, then you’d still need some kind of protocol for adding data to that database.

    But: Why don’t you first look at the tools in MS Access to natively create a form from there?

    Thread Starter eglider

    (@eglider)

    I have found caspio and it does exactly what i have looked for. Thank you!

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Add data via WP site to database’ is closed to new replies.