OpenRecordSets and Adding Data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Does the table in question have a primary key defined? It must, or it will
be read-only,
 
Back
Top