I have a .asp search facility connecting to an Access .mdb database. The search pages and results pages were designed in Dreamweaver.


I want to expand the pages to allow online data entry to the database. Can anyone point me to a good easy to follow tutorial or example on how to use Dreamweaver and .asp pages to write to an Access .mdb database through textboxes etc?

Its really simple to create a page to do this in dreamweacer.

- Create a new .asp page and create a regular form on it with a form field for each database field you are going to use and a submit button.

- On the server behaviours panel choose insert record behaviour

-Choose the connection and table you are using from the drop down lists and type the name of the page you want to go to after the insert (can be the same page if you want)

- Then match up the names of the form fields with the fields you want to write to the database. (Highlight the form field from the list and then choose the database field from the drop dopwn list below. if you gave the form fields the same name as the database fields this should be done for you automatically)

- Choose how to submit each field using the other drop down. Its easiest to use text for most fields if you have any dates though you should pick MS ACCESS DATE

- Click OK and your done.

If you need more help I would reccomend the dreamweaver help. just click the help button on the insert record dialog box.

Thanks for your reply, I should have mentioned that the database I want to access has multiple table relations, and I need to be able to insert records across the related tables from a single dreamweaver form.