By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
426,165 Members | 1,928 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 426,165 IT Pros & Developers. It's quick & easy.

Jet DB Engine and parameterized UPDATE query

P: n/a
Hi all.

I am having a strange problem.

I am developping an application that acceses an Access db through Jet
(.UDL files).

I have writen parametric INSERT queries that work fine.
I am now trying to write a parametric UPDATE query but I always get a
return error code that the language manual translates to:

Exception occurred in Microsoft JET Database Engine, Operation must use
an updateable query.

I have looked at file and directory permissions, but everything looks
ok.

Does anyone have any clues to why parametric INSERT works and UPDATE
does not?

Thanks in advance.

G.
--
Posted via Mailgate.ORG Server - http://www.Mailgate.ORG
Nov 13 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
how about posting your code and SQL statement... I see no reason why a
parameterized update query wouldn't work...

Nov 13 '05 #2

P: n/a
Access has some irritating habits that make little sense when it comes
to UPDATE queries.
If any portion of the recordset is not updateable you get that
'Operation must use an updateable query' message.
For example you may have an outer join, or a linked read only table, or
a non-updateable query joined to the table you are trying to update.
Even though you are not updating the non-updateable items, access won't
let you do it.
My solutions have been to put sql in an IN statement to limit the
recordset instead of a join, or to make a temp table (which I detest).
HTH
P

Nov 13 '05 #3

P: n/a
"pietlinden" <pi********@hotmail.com> wrote in message
news:11********************@o13g2000cwo.googlegrou ps.com
how about posting your code and SQL statement... I see no reason why a
parameterized update query wouldn't work...

Not very simple since I am working in LabView.
It actually uses ADO underneath, so I copied the function from the
INSERT query (that works perfectly) and modified the SQL statement
generation. I did not touch the ADO calls that build the parametric
query.
G.
--
Posted via Mailgate.ORG Server - http://www.Mailgate.ORG
Nov 13 '05 #4

P: n/a
"dedejavu" <de******@hotmail.com> wrote in message
news:11**********************@z14g2000cwz.googlegr oups.com
Access has some irritating habits that make little sense when it comes
to UPDATE queries.
If any portion of the recordset is not updateable you get that
'Operation must use an updateable query' message.
For example you may have an outer join, or a linked read only table, or
a non-updateable query joined to the table you are trying to update.
Even though you are not updating the non-updateable items, access won't
let you do it.
My solutions have been to put sql in an IN statement to limit the
recordset instead of a join, or to make a temp table (which I detest).
HTH
P

Non of these things!

I am trying to update ONE single table.
G.

--
Posted via Mailgate.ORG Server - http://www.Mailgate.ORG
Nov 13 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.