Skip to main content
May 9, 2006
Answered

Inserting form data into Access database

  • May 9, 2006
  • 2 replies
  • 630 views
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.
This topic has been closed for replies.
Correct answer
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...

2 replies

Correct answer
May 9, 2006
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...
Inspiring
May 9, 2006
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.
>
>