Solved

Error using insert sql in ASP -Access, NT4.0

Posted on 1998-12-08
2
219 Views
Last Modified: 2013-12-25
I get an operation must use an updatable query error when trying to instert a record into an access(97) database. Server is NT 4.0, IIS, The asp script is listed below:

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Microsoft Access 97 Driver] Operation must use an updatable query.

/findit/signinhandle.asp, line 50

Conn.Open  "DBQ=C:\wwwroot\guestbook\guest.mdb;DefaultDir=c:\wwwroot\guestbook;Driver={Microsoft Access Driver (*.mdb)};DriverId=25;FIL=MS Access;ImplicitCommitSync=Yes;MaxBufferSize=512;MaxScanRows=8;PageTimeout=5;SafeTransactions=0;Threads=3;UID=admin;UserCommitSync=Yes;"

sql = "INSERT INTO tblGuests(Name, EMail, Address1, Address2, City, State, Zip, Kiss, Rock, CheapTrick, ClassicRock, Alt, refer, Comment, Host_Name) "
sql = sql & "VALUES('" & Request("uName") & "', '" & Request("ueMAIL") & "', '" & Request("uaddress1") & "', '" & Request("uaddress2") & "', '"
sql = sql & Request("uCity") & "', '" & Request("uState") & "', '" & Request("uZip") & "', '" & Request("uKiss") & "', '" & Request("uRock") & "', '" & Request("uCheapTrick") & "', '" & Request("uClassicRock") & "', '" & Request("uAlt") & "', '" & Request("urefer") & "', '" & Request("ucomment") &"', '" & CStr(Request.ServerVariables("REMOTE_HOST")) &  "')"
                  
Conn.Execute(sql)
0
Comment
Question by:expert69
2 Comments
 

Accepted Solution

by:
krassiB earned 100 total points
ID: 1830048
Possibly you do not have enough permissions on the database file for Internet Guest account IUSR_MACHINE. You can change this from changing NT security permissions for the guest.mdb and guest.ldb files(or guestbook directory with replase permissions on existing files). Give them change permission (RWXD).

If this does not work see in
http://microsoft.com/support
Knowledge base Article ID: Q175168
I think this will help!
0
 

Author Comment

by:expert69
ID: 1830049
Thanks for the answer.
0

Featured Post

Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

Question has a verified solution.

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

Ever wondered how to display how many visitors you have online. In this tutorial I will show you an easy but effective way to display the number of online visitors in WhizBase. In this article I assume you have read my previous articles and know …
This article will show, step by step, how to integrate R code into a R Sweave document
Learn the basics of lists in Python. Lists, as their name suggests, are a means for ordering and storing values. : Lists are declared using brackets; for example: t = [1, 2, 3]: Lists may contain a mix of data types; for example: t = ['string', 1, T…
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

822 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