I am uncertain of how to handle this error and fix it so that I can update 
the record in a database.
error:
database or object is read only. error # 2147217911

it consistes of 2 tables.  updating 2nd table with key of 1st database.  
Code used with error.

code used:

dim sqlstr2 as string

sqlstr2 = "SELECT * from tbl_vendor, tbl_schedule where schprtchk = " & 
"true and tbl_vendor.primkey = tbl_schedule.vendorkey"

rsprtchk.open sqlstr2, connectionstr, adopendynamic,adlockoptimistic

on error goto transerror

rsprtchk.movefirst

connectionstr.begintrans

rsprtchk!schchkno = val(mshflexgrid1.text)    ' is a number in text 
converted to a number

rsprtchk.update
connectionstr.committrans
rsprtchk.close

exit sub
__________________________
errortrans3:

connectionstr.rollback
msgbox err.description & err.number
rsprtchk.close

exit sub

_____________________________
this is same routine used in another update to the database except i just 
update main table (tbl_vendor)

I am thinking that this logic needs the inner join on table but not sure 
how to do it.

help please this is the last piece i need for this segment of the vb 
project.

thanks,

krunch92@m...