Very Computer

I am using Visual Basic 5.0 with a 32bit odbc to connect to an sql
server.  I can read data from the server, but I can't write data back to
it...i've tried different methods, what am I doing wrong?  Here is a
sample...

dim db as database
dim rst as recordset

set db=opendatabase("",dbDriverNoPrompt,
False"UID=sa;PWD=12345;DSN=APOLLO")

set rst=db.openrecordset("select * from tblsysNumbers")

number=rst![SalesOrderNumber]

newnumber=number +1

rst.edit
    rst![SalesOrderNumber]=newnumber
rst.update

rst.close
db.close

When I run the above, I get the following error:

Can't Update Database or Object is Read-Only...

Anyone know the answers.......

Robert Romano

Robert,
A quick suggestion is to see if your table has a primary key defined.. You need
a primary key defined to be able to modify the records.

HTH,

Tom

Solidus Computer Systems