473,557 Members | 2,830 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Question: Operation Must Use an Updateable Query

Hi -
I am having a bit of a problem with the insert into a database. When I go
to insert a record into an un-keyed, single table Access database, I get the
aforementioned ''Operation Must Use an Updateable Query' error.

Points:
- The database is in my local temp directory, not inetpub
- The directory has read/write permissions
- The database has read/write permissions
- I created another version of the dbase and tried to reference it with the
same result
- I can access the dbase and sucessfully select rows from the database to
populate a datagrid

Other points:
- Database sucessfully opens and closes
- IIS was installed after the VB.net code. I re-ran gacutil to re-register
dlls

Code Snippet:
Dim mSQL As String = "INSERT INTO Messages(LastNa me, FirstName,
EmailAddress, MessageDate, Message) VALUES ('Smith','John' ,
's********@mail .com','10/26/2003','stuffs') "
Dim objCmd As New OleDbCommand(mS QL, cn)

Try
objCmd.ExecuteN onQuery()

Catch ex As Exception
Label.Text = ex.Message

End Try

I am not sure at this point whether this is a VB or ADO issue. Any thoughts
or suggestions would be greatly appreciated.
- Sheryl
Nov 20 '05 #1
2 7505
Check out this link.. there's a Knowledgebase article about
this...http://www.dotnet247.com/247referenc.../14/74813.aspx

However, can you fire any updates, insert or deletes? Basically, will this
query definitely run if you do it from within access? If you were using a
CommandBuilder or DA Configuratino wizard, the problem would probably be the
lack of a key, but that doesn't appear to be the problem. If you are sure
the query will run, then the link above is the most likely solution.

HTH,

Bill
"SheryMich" <sm******@yahoo .com> wrote in message
news:Kr******** *********@newsr ead1.news.atl.e arthlink.net...
Hi -
I am having a bit of a problem with the insert into a database. When I go
to insert a record into an un-keyed, single table Access database, I get the aforementioned ''Operation Must Use an Updateable Query' error.

Points:
- The database is in my local temp directory, not inetpub
- The directory has read/write permissions
- The database has read/write permissions
- I created another version of the dbase and tried to reference it with the same result
- I can access the dbase and sucessfully select rows from the database to
populate a datagrid

Other points:
- Database sucessfully opens and closes
- IIS was installed after the VB.net code. I re-ran gacutil to re-register
dlls

Code Snippet:
Dim mSQL As String = "INSERT INTO Messages(LastNa me, FirstName,
EmailAddress, MessageDate, Message) VALUES ('Smith','John' ,
's********@mail .com','10/26/2003','stuffs') "
Dim objCmd As New OleDbCommand(mS QL, cn)

Try
objCmd.ExecuteN onQuery()

Catch ex As Exception
Label.Text = ex.Message

End Try

I am not sure at this point whether this is a VB or ADO issue. Any thoughts or suggestions would be greatly appreciated.
- Sheryl

Nov 20 '05 #2
Bob
Hiya,

You say the database and the directory it is in have read/write access...
but for who? If you are running the ASP under the default IIS account you
will need to explicitly set permissions for that account on the file and
folder. By default the IIS account (IUSR_ComputerN ame) has permissions to
bugger all.

Even if you are running the ASP under a user account you will still need to
ensure it has permissions but the IUSR account is very limited so least
likely to work by default.

Also, you don't show how you open the database so we have to assume you
didn't open it read only...

Try these search results for more info:

http://search.microsoft.com/search/r...qa=&qn=&c=&s=0

Cheers

"SheryMich" <sm******@yahoo .com> wrote in message
news:Kr******** *********@newsr ead1.news.atl.e arthlink.net...
Hi -
I am having a bit of a problem with the insert into a database. When I go
to insert a record into an un-keyed, single table Access database, I get the aforementioned ''Operation Must Use an Updateable Query' error.

Points:
- The database is in my local temp directory, not inetpub
- The directory has read/write permissions
- The database has read/write permissions
- I created another version of the dbase and tried to reference it with the same result
- I can access the dbase and sucessfully select rows from the database to
populate a datagrid

Other points:
- Database sucessfully opens and closes
- IIS was installed after the VB.net code. I re-ran gacutil to re-register
dlls

Code Snippet:
Dim mSQL As String = "INSERT INTO Messages(LastNa me, FirstName,
EmailAddress, MessageDate, Message) VALUES ('Smith','John' ,
's********@mail .com','10/26/2003','stuffs') "
Dim objCmd As New OleDbCommand(mS QL, cn)

Try
objCmd.ExecuteN onQuery()

Catch ex As Exception
Label.Text = ex.Message

End Try

I am not sure at this point whether this is a VB or ADO issue. Any thoughts or suggestions would be greatly appreciated.
- Sheryl

Nov 20 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

8
902
by: Tom wilson | last post by:
This is driving me nuts. I'm trying to update an Excel spreadsheet using ADO.Net and Oledb in VB.Net. The connection is open, the adapter is connected and the dataset is loaded. Here's the code in question: myDataRow = myDataSet.Tables(0).Rows(RowNum) myDataRow(ColumnCount) = Ailment Adapter.UpdateCommand = New OleDbCommand("UPDATE SET...
6
7550
by: ano1optimist | last post by:
I have been running these queries in Access 2000 with no problems. This week, I had to install Access 2003 to create some runtime versions for another application, and now I keep getting "operation must be an updateable query" messages when I try to run the same old queries. Here is a sample of one that is no longer working: UPDATE...
4
6496
by: MDW | last post by:
Hey all. I'm confused. I'm trying to add a single record into an Access 2000 database using ASP.Net. Here is the code: objConn = New OleDbConnection(strConnect) objConn.Open objCommand = New OleDbCommand("INSERT INTO LOGIN_MASTER (LOGIN_ID, PWD, F_NAME, L_NAME, TYPE_ID) VALUES ('" & strEmail & "','" & strPwd & "','" &
606
14386
by: Neil Zanella | last post by:
Hello, I am trying to update an MS access database from ASP.NET. I am using IIS on Windows XP Pro. I can issue SELECT statements from ASP.NET using ADO.NET but I cannot seem to be able to carry out INSERT statements. Here is the error which I am getting: Exception Details: System.Data.OleDb.OleDbException: Operation must use an...
4
302
by: Derek Van Cuyk | last post by:
Hi everyone! I'm trying to write a web application in school that utilizes a MS Access database. I can read and everything fine from it but when I try to add a new record I get an exception that states: "Operation must use an updateable query" I know it has to do with the update command on the OleDbDataAdapter. I've tried looking for the...
8
2997
by: Jim in Arizona | last post by:
I've been using an example out of a book to be able to edit the rows in a database. I am getting the following error: ======================================================== ======================================================== Server Error in '/' Application....
1
3574
by: Muskito | last post by:
HELP!!! Hello All, I'm using VB.net 2003 and trying to update data in Excel worksheet. The program selects data from the excel, updates something in the MSSQL DB and then tries to update something back to the excel worksheet. My problem is that i'm having this annoying exception: "Operation must
11
3938
by: Arpan | last post by:
I have always been working with SQL Server 2005 for ASP.NET apps but due to some reasons, had to revert back to MS-Access 2000. When I try to insert/update a MS-Access DB table (MDB), ASP.NET generates the following error: Operation must use an updateable query. pointing to a line that says
1
2746
by: pavya | last post by:
Hi, I have developed one Web application. At that time my system had a FAT file system on it and this application worked properly. But now i have converted FAT file system to NTFS file system and whenever i am trying to run this application then it through the exception. I have used MS Access as a database. The error is as follows... Server...
0
7549
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
0
7830
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...
0
8061
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
0
6180
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
0
5172
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...
0
3599
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
1
2044
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
1
1161
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
867
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.