Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Inserting data into access database using ASP

Posted on 2004-03-29
2
Medium Priority
?
11,281 Views
Last Modified: 2013-12-14
This is the error I am getting: Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.
/wc/Addnew.asp, line 19


Here is my code:

<% @LANGUAGE=VBScript %>
<HTML>
  <HEAD>
    <TITLE> Inserting Data into a database table </TITLE>
<%
  Dim objConn, objRS, strSQL
  Dim strConnection
 
  Set objConn = Server.CreateObject("ADODB.Connection")
  strConnection = "DSN=Shoponline;Database=Shoponline.mdb;"
  strConnection = strConnection & "UID=;PWD=;"
  with objConn
      .ConnectionTimeout=20
      .Open strConnection
  end with
 
  strSQL = "INSERT INTO tblProduct (Description, Price) VALUES "
  strSQL = strSQL & "('Cannon', '15.50')"
  objConn.Execute strSQL  'no recordset returned
  objConn.Close
  set objconn=nothing
%>
</HTML>

Please help!!
0
Comment
Question by:sikan71
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 1

Accepted Solution

by:
twhite333 earned 200 total points
ID: 10746126
Try reading this.  I think it will help.

http://forums.aspfree.com/t21541/s.html

TW3
0

Featured Post

Looking for a new Web Host?

Lunarpages' assortment of hosting products and solutions ensure a perfect fit for anyone looking to get their vision or products to market. Our award winning customer support and 30-day money back guarantee show the pride we take in being the industry's premier MSP.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you’re involved with your company’s wide area network (WAN), you’ve probably heard about SD-WANs. They’re the “boy wonder” of networking, ostensibly allowing companies to replace expensive MPLS lines with low-cost Internet access. But, are they …
This article is a collection of issues that people face from time to time and possible solutions to those issues. I hope you enjoy reading it.
Viewers will learn how to connect to a wireless network using the network security key. They will also learn how to access the IP address and DNS server for connections that must be done manually. After setting up a router, find the network security…
Internet Business Fax to Email Made Easy - With  eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, f…

722 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question