Solved

Inserting data into access database using ASP

Posted on 2004-03-29
2
11,264 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
2 Comments
 
LVL 1

Accepted Solution

by:
twhite333 earned 50 total points
Comment Utility
Try reading this.  I think it will help.

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

TW3
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Article by: IanTh
Hi Guys After a whole weekend getting wake on lan over the internet working, I thought I would share the experience. Your firewall has to have a port forward for port 9 udp to your local broadcast x.x.x.255 but if that doesnt work, do it to a …
What’s a web proxy server? A proxy server is a server that goes between clients and web servers, used in corporate to enforce corporate browsing policy and ensure security. Proxy servers are commonly used in three modes. A)    Forward proxy …
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…
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…

743 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now