Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Inserting data into access database using ASP

Posted on 2004-03-29
2
Medium Priority
?
11,285 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
1 Comment
 
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

Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

Question has a verified solution.

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

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.
WARNING:   If you follow the instructions here, you will wipe out your VTP and VLAN configurations.  Make sure you have backed up your switch!!! I recently had some issues with a few low-end Cisco routers (RV325) and I opened a case with Cisco TA…
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…
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …

772 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