InfoPath Dev

Thanks for your reply Jo-Anne. To simplify the environment, I made up a simple Access database on my computer with one table and two fields. Then I made up an InfoPath form to work with it. When submitting a record I got the same “Access Denied” error. Searching the internet for a solution, it seems that changing the security (under form options) ...

I created a test database on my SQL server. It has one table with two fields - a "unique record ID" and a field called "Name". Then I setup a new InfoPath form based on the database. It does allow the Submit option. I dragged the name field to my form, previewed the form, entered a name and tried to submit it. It failed giving ...