Inserting form data into Access database

[Guest]

Hi (ASP.NET & Access database question)

I have created a simple aspx form with 3 fields (txt.contact_name, txt.email, txt.comments). What i would like to do is when a user clicks the submit button the information supplied is fed into an Access database table (contact_name, email, comments). Can anyone shed light on how I can do this?

I usually use SQL Server and using that database I would normally create a stored procedure for the insert statement but I am having problems creating a stored procedure in Access 2000.

[Newsgroup_User]

Access doesn't support stored procedures. You can create a "view" in the
Access query builder and refer to that in the Dreamweaver interface.

But this should truly be a simple Insert Record .. did you not use the
Insert Record Behavior?


--
Nancy Gill
Adobe Community Expert
BLOG: http://www.dmxwishes.com/blog.asp
Author: Dreamweaver 8 e-book for the DMX Zone
Co-Author: Dreamweaver MX: Instant Troubleshooter (August, 2003)
Technical Editor: DMX 2004: The Complete Reference, DMX 2004: A Beginner's
Guide, Mastering Macromedia Contribute
Technical Reviewer: Dynamic Dreamweaver MX/DMX: Advanced PHP Web Development


"ricky0110" <webforumsuser@macromedia.com> wrote in message
news:e3q4q7$2et$1@forums.macromedia.com...
> Hi (ASP.NET & Access database question)
>
> I have created a simple aspx form with 3 fields (txt.contact_name,
> txt.email,
> txt.comments). What i would like to do is when a user clicks the submit
> button
> the information supplied is fed into an Access database table
> (contact_name,
> email, comments). Can anyone shed light on how I can do this?
>
> I usually use SQL Server and using that database I would normally create a
> stored procedure for the insert statement but I am having problems
> creating a
> stored procedure in Access 2000.
>
>

[Guest · Accepted solution]

Nancy

Thanks I totally forgot about the Insert Record Behaviour. Been working on VS2005 & SQL for the last 6 months and forgot about the basics of Dreamweaver. Happy now...