Re: How to add/delete records from database table using infopath.

Hilary Stoupa — Sat, 08 Apr 2017 12:37:25 GMT

This should be fine with InfoPath and you don't have to have SharePoint. From the InfoPath Designer, under New, you can select "Database" as your starting point for your form - this will allow you to connect to your database.

Here are some links that may help you:

https://msdn.microsoft.com/en-us/library/office/ee526347.aspx
https://support.office.com/en-us/article/Submit-form-data-to-a-Microsoft-SQL-Server-database-15fd82dc-8077-4737-bc13-94d993bc84af
https://support.office.com/en-us/article/Introduction-to-submitting-form-data-29b2e228-568d-4d97-bebb-8a92fde59c98

The data connection will have query fields and data fields. You can use the query fields to help him find the user he needs to delete - then in the returned results (displayed in the data fields), he can remove the repeating row with the user he wishes to delete and submit the form to update the database. For adding new, he can insert a new row in the repeating data fields section, enter data and submit.

How to add/delete records from database table using infopath.

bobghw — Thu, 06 Apr 2017 20:07:56 GMT

I need to create a form so a user can add new records or delete existing records in a database table. This is not something that he has to do a lot of, basically add new users and delete old users. So it just needs to be a simple form. Is there a tutorial somewhere that will walk me through this? We don't use sharepoint will that be a problem?

Newbie Questions

Re: How to add/delete records from database table using infopath.

How to add/delete records from database table using infopath.