Solved

Inserting data into access database using ASP

Posted on 2004-03-29
2
11,274 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 50 total points
ID: 10746126
Try reading this.  I think it will help.

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

TW3
0

Featured Post

WordPress Tutorial 4: Recommended Plugins

Now that you have WordPress installed, understand the interface, and know how to install new parts, let’s take a look at our recommended plugins.

Question has a verified solution.

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

When you try to share a printer , you may receive one of the following error messages. Error message when you use the Add Printer Wizard to share a printer: Windows could not share your printer. Operation could not be completed (Error 0x000006…
In this article, I am going to show you how to simulate a multi-site Lab environment on a single Hyper-V host. I use this method successfully in my own lab to simulate three fully routed global AD Sites on a Windows 10 Hyper-V host.
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…
Suggested Courses
Course of the Month11 days, left to enroll

632 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