pleth

I am totally stumped on this one. Please, God, help me:

I have a set of code which updates an underlying Access table. I swear that I have seen it work in one place, then in another it will give me error numbers -2147467259 or -2147217864, with the cryptic messages that the "operation must use an updatable query" or "not enough base table information". Here's a sample of code:

Adodc1.Refresh
Adodc1.Recordset.MoveFirst
While (Not Adodc1.Recordset.EOF)
With Adodc1.Recordset
If intdummy = !scode Then
If Int(!CandNo) Mod Int(Text1.text) = 0 Then
intRoom = intRoom + 1
End If
If !CandNo < 226 Then
!Room = "0" & intRoom
Else
!Room = intRoom
End If
.Update
.MoveNext
Else
intRoom = 1
intdummy = !scode
End If
End With
Wend

All this does is put a bunch of people into different "rooms" based on group size defined by the user (text1.text). But it ALWAYS gets stuck on .Update. Why? I'm going crazy!

sunbin

Check if there is a value there for updating... Do u understand?

try using breakpoint to see if there is value for
check !room etc.
if there is no vlaue, how can it update...

and one more thing.... make sure that the data type in the database is an "number"

Let's see wht's the problem will be

pleth

no, didn't work. all variables have values. sorry about the confusion with the dimension.... introom is actually a string variable. !room writes to a text field.

i'm telling you, this one is crazy!

iowahawk43

It seems as if your settings might be for read-only, if you take the error message literally??? Check your properties in the adodc control...better yet, write code without the data control.

Hope this helps.

vb6guru2

There could be a few problems here. If your ADO Recordsource is a query, with joins that have no real PK in either of the tables, it will be a read only query regardless of the adodc settings.

Use:


To determine if the recordset itself can perform an update. If not... there's your answer. If so... come on back.

Mikecrosoft

Where is the Adodc1.Recordset.AddNew ???

martin82

This message is normally caused (from VB) by trying to do something to a DB that has been opened in 'Read' instead of 'ReadWrite' mode.

That's normally set in the DB connect string.

Quote:

---

Originally Posted by pleth
I am totally stumped on this one. Please, God, help me:

I have a set of code which updates an underlying Access table. I swear that I have seen it work in one place, then in another it will give me error numbers -2147467259 or -2147217864, with the cryptic messages that the "operation must use an updatable query" or "not enough base table information". Here's a sample of code:

Adodc1.Refresh
Adodc1.Recordset.MoveFirst
While (Not Adodc1.Recordset.EOF)
With Adodc1.Recordset
If intdummy = !scode Then
If Int(!CandNo) Mod Int(Text1.text) = 0 Then
intRoom = intRoom + 1
End If
If !CandNo < 226 Then
!Room = "0" & intRoom
Else
!Room = intRoom
End If
.Update
.MoveNext
Else
intRoom = 1
intdummy = !scode
End If
End With
Wend

All this does is put a bunch of people into different "rooms" based on group size defined by the user (text1.text). But it ALWAYS gets stuck on .Update. Why? I'm going crazy!

---