ok this is what I am looking to achieve:
1. Form to collect data into a SQL database. This form will be made available via Sharepoint, but the data is to be captured into a database to allow for easy reporting.
2. Users completing the form do not have access to InfoPath, so the code will need to be altered to allow for the form to be completed ...