Access database query using sql help !!!

[ORACLE]

Access database query using sql help !!!
I am using vb 6.
I get a message saying query too complex, i have loads of check boxes acting as cinema seats, that are booked and not booked.
Im current using this:

Adodc1.Recordset.Update
Adodc1.Recordset.Requery

Can anyone tell me how to maybe save it in a different way???
maybe like this??

Adodc1.Recordset.Fields("r1-1") = Check1
Adodc1.Recordset.Fields("r1-2") = Check2
Adodc1.Recordset.Fields("r1-3") = Check3
Adodc1.Recordset.Fields("r1-4") = Check4
Adodc1.Recordset.Fields("r1-5") = Check5

thanks for any help, i need this very soon, sorry about the rush.
thanks

[Lop]

Is it possible for you to show us the query?

[ORACLE]

I am trying to save the follwing data types (check boxes) to my database as shown it these images:
Example here in Vb

This is it running:
Example running

My database name is: cinema

My table is: booking

And my table is layed out as show bellow:
Click here
It go's "r1-1" up to "r1-20"
It go's "r2-1" up to "r2-20"
It go's "r3-1" up to "r3-20"
It go's "r4-1" up to "r4-20"
It go's "r5-1" up to "r5-20"
It go's "r6-1" up to "r6-20"

hope this makes it clear now
thanks in advanced
ORACLE

[ORACLE]

should i busing ADO

[NeedHelp]

I'm not sure but it can't hurt to try:

DB2 Universal Database