Adding data to an Access database.

Report · Jul 14, 2006

I'm about to lose my mind! I can not successfully add a record to my Microsoft Access Database in Dreamweaver. I was able to create a connection to my database and the insert record form looks great on my .asp page, but when I click insert.....NOTHING HAPPENS!!! What the devil am I doing wrong???? I believe that part of the problem is related to the "After inserting,go to:" where I'm supposed to choose a page that my visitors will go to after they insert the record. When the insert record button is clicked, I get directed to "This page cannot be displayed". Any help would be GREATLY apprecited.
Ron D.

Report · Jul 14, 2006

What reason does it give for not displaying the page? Is it 404 (Can't Be
Found)? Did you upload the second page to your server?

As far as the insert not happening .. did you set permissions so the
database can be written on?

--
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

"rondan1955" <webforumsuser@macromedia.com> wrote in message
news:e986th$i8a$1@forums.macromedia.com...
> I'm about to lose my mind! I can not successfully add a record to my
> Microsoft
> Access Database in Dreamweaver. I was able to create a connection to my
> database and the insert record form looks great on my .asp page, but when
> I
> click insert.....NOTHING HAPPENS!!! What the devil am I doing wrong???? I
> believe that part of the problem is related to the "After inserting,go
> to:"
> where I'm supposed to choose a page that my visitors will go to after they
> insert the record. When the insert record button is clicked, I get
> directed to
> "This page cannot be displayed". Any help would be GREATLY apprecited.
> Ron D.
>

Report · Jul 14, 2006

Thanks Nancy, I thought I had already set the permissions but it turns out I was setting them in the wrong place. Your reply made me dig further and I realized that it was the database connection, not the database itself that needed the "write" permission. Thank you for your help. Problem solved!

Report · Jul 14, 2006

Terrific!

Nancy

"rondan1955" <webforumsuser@macromedia.com> wrote in message
news:e98dg6$qhm$1@forums.macromedia.com...
> Thanks Nancy, I thought I had already set the permissions but it turns out
> I
> was setting them in the wrong place. Your reply made me dig further and I
> realized that it was the database connection, not the database itself that
> needed the "write" permission. Thank you for your help. Problem solved!
>