OpenRecordSets and Adding Data

P

Paul

Hi,

I have an input form which people fill in with data, i then use a command
button to send this data to a linked table from sql 2005, when i click the
button to put the data into the linked table it says the following:-

Cannot Update. Database or object is read-only.

Can someone help me to understand how to make the table not read only so it
will accept the data I am trying to insert into it?

Thanks

Paul
 
D

Douglas J. Steele

Does the table in question have a primary key defined? It must, or it will
be read-only,
 
Top