Please kindly help me out with this operation must use an updatable query in VB.NET

Question

1.00/5 (2 votes)

See more:

hi, please help me with this, After i deployed my project with installsheild whenever i tried to save a data it keeps saying 'operation must use an updatable query

What I have tried:

i have tried everything i can, please kindly help me out so i can finish the project on time

Posted 12-Sep-17 1:27am

Member 13341316

Updated 12-Sep-17 1:36am

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2017-09-12T01:36:00

Solution 1

We can't help you - we don't have any access to your code!

At a guess, it's your connection string - did you update it for the new network the software is deployed on?

So start at the beginning. Probably you can't use the debugger - it's unlikely the target PC will have VS installed - so you will have to fall back on older methods, namely logging.
Add logging statements to your code to try and isolate which part of your software is generating the error. When you know the rough area, you can start adding more intense logging in that area to narrow it down further. At some point, the logging will need to include variable contents, string values such as connection strings and use input, and so forth. Each time you add more logging, you will need to reissue the new software to the target machine.

That should get you pointed in the right direction, or at least give you information you can feed to us.

Don't forget to remove the logging once you fixed the problem!

Posted 12-Sep-17 1:36am

OriginalGriff

Comments

Member 13341316 12-Sep-17 7:43am

Public Class Admission

Private Sub Button6_Click(sender As Object, e As EventArgs) Handles Button6.Click
Dim conn As New OleDb.OleDbConnection
Dim connStr As String = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|\Buthdatabase.accdb;Persist Security Info=False"
Dim cmd As New OleDb.OleDbCommand

Try
conn.ConnectionString = connStr
conn.Open()
cmd.Connection = conn

cmd.CommandText = "INSERT INTO Admission ([Hospital No],[Patient's Name],[Date Attended],[Reffered By],[Consultant],[Ward],[Date Discharged],[Discharged To],[Condition On Discharge],[Discharge Summary]) " & _
"VALUES ([@HospitalNo],[@Patient'sName],[@DateAttended],[@RefferedBy],[@Consultant],[@Ward],[@DateDischarged],[@DischargedTo],[@ConditionOnDischarge],[@DischargeSummary]); "

cmd.Parameters.AddWithValue("@HospitalNo", Hospital_NoTextBox.Text)
cmd.Parameters.AddWithValue("@Patient'sName", Patient_s_NameTextBox.Text)
cmd.Parameters.AddWithValue("@DateAttended", DateTime.Text)
cmd.Parameters.AddWithValue("@RefferedBy", Reffered_ByTextBox.Text)
cmd.Parameters.AddWithValue("@Consultant", ConsultantTextBox.Text)
cmd.Parameters.AddWithValue("@Ward", WardTextBox.Text)
cmd.Parameters.AddWithValue("@DateDischarged", DateTime1.Text)
cmd.Parameters.AddWithValue("@DischargedTo", Discharged_ToTextBox.Text)
cmd.Parameters.AddWithValue("@ConditionOnDischarge", Condition_On_DischargeTextBox.Text)
cmd.Parameters.AddWithValue("@DischargeSummary", Discharge_SummaryTextBox.Text)

cmd.ExecuteNonQuery()
conn.Close()
Catch ex As Exception
MessageBox.Show(ex.Message)
End Try
End Sub

OriginalGriff 12-Sep-17 7:52am

And what results do you get?
What does logging show you is happening?

Member 13341316 12-Sep-17 7:54am

Operation must use an updateable query, that is what its showing

OriginalGriff 12-Sep-17 7:59am

:sigh:
No, that's what your message is showing. It doesn't tell us what line is generating the error, or any of the variable contents.

I can't run your code: I don't have your data, I don't have your user inputs. You are going to have to do the donkey work here!

On a side note, why the heck are you passing Dates as strings? You aren't storing them as strings are you? That would be silly...

Richard Deeming 12-Sep-17 16:35pm

The most common cause of that error is that the user doesn't have permission to write to the folder where the database is stored.

I see you're storing the database file in the application directory. Have you installed the application in a privileged location, like C:\Program Files\Your Application\ for example?

You'll need to install the database file in a folder which the user can write to - typically something under the user's profile, in the "application data" folder, or to the system-level "program data" folder.

Alternatively, ditch Access and upgrade to a proper multi-user DBMS - eg: SQL Server Express[^] or PostgreSQL[^]. But that's a much more complicated option.

Member 13341316 12-Sep-17 8:02am

is their a way i can send my project to you

OriginalGriff 12-Sep-17 8:12am

No! :laugh:
This is part of your task: and it's not going to be the last time you have to do this. So bite the bullet and start learning how to debug on a small project - it will only get harder when you get to the "real-world" stuff.

Member 13341316 12-Sep-17 8:13am

https://drive.google.com/open?id=0B3TbJAnEMncGTllQbkJuWXl2bnc

Member 13341316 12-Sep-17 8:14am

please kindly help me out thats the link to the project. please download it and help me out

OriginalGriff 12-Sep-17 8:25am

No. I have no idea what your code does, and I'm not running unknown code on my dev machine! Would you?

So start logging what is happening and find out information. It's only a little method: it shouldn't take you more than a few minutes to add it all if you logged every line!

Member 13341316 12-Sep-17 10:21am

ok