I will be creating a number of PDF forms for completion by engineers who service air conditioning units to record the condition of various components in the units. Once the form is completed I would like to submit the data to a MS Access/SQL database (i have not made my mind up with one to use).
I am looking for some references/support in the following areas:
Shoud I use Access or SQL. I understand if i use Access I would have to setup a 'connection' for each computer that would be using the PDFs. Also, i feel I would lose a lot of the power of SQL by using Access.
I was thinking of creating a w web service that points at a SQL database. Are there any good examples of a PDF form that does this? Also, does this remove the need to create a connection for every computer that will be using the PDFs?
I thank you in advance for any comments or suggestions.