As you can probably guess from the title, I'm trying to figure out why I keep getting an HTTP 500 Error whenever I try to insert a record into my Access 2000 database from my web page.
The database is writable as I can add / remove users, and modify other records. Basically I had a simple 2 field "Add News" page setup built in DreamWeaver MX. Title & Story were the fields. This worked fine. But I didn't feel like displaying a 3 paragraph news item on the home page, so I decided to add an "Introductory" field. This way only a small portion of the news is displayed, then the user clicks on then news item and it takes them to the "news.asp" page where the full story is displayed. I added the appropriate field to the table in the database and added an extra field in my form on the ASP page. I updated the "Insert Recordset" function to include the new field, and now my page gives me an HTTP 500 Error whenever I click the "Add News" button.
I'm including a link to a .txt with the code for the "add_news.asp" page. I have tried different database connection options as well.
To see the live example, go to: http://www.epic-graphics.com/instatel.ca/admin
Thanks for any help!