Connecting a Dreamweaver input form to Access
Posted on 2005-03-18
I have created a an input from for my Dreamweaver website; I would like people to fill out the form with their name, email etc and click a submit button; the problem is that I can't get it to connect to my Access database even though I have set up my DSN connection.
Here is what I did so far.
1) I created a connection using Data Source name from the databases under the Applications menu. I used the option of DSN on testing server; I tested it and it connected successfully
2) I created a Recordset from the Bindings menu. it showed my connection and table. Again I tested the connection and it was successful.
3) I created an Insert Record and chose the table in my database.
4) I saved everything and and uploaded the form.
However, when I put information and click submit, I get an error message and no info show up in the database. I tried this several times. I am not sure if I am missing something.
If any one can tell me what I did wrong, I would appreciate it