Why isn't recordset updatable? 2

[grnzbra]

I have a simple SQL Server 2000 database. I created an Access XP project linked to existing database. Used the form wizard to create a form referencing one of the tables. When the wizard was finished, the form was blank, although the design view showed the appropriate text boxes. When I went back to SQL Server and entered one record directly int the table and then went back to the form, the fields showed the record. When I went to change one of the fields, I got a message that the recordset wasn't updatabale. Any suggestions why?

 

[fearnan]

There could be several reasons why.

Primarily you will want to check out the 'Unique Table' property of the form.

other things to check are the usual 'allow additions', edits,deletions properties toooo

;-)

 

[cjowsey]

Make sure you have a primary key defined on the SQL Server table so Access can uniquely identify each row.

 

[bmc1976]

Make sure you defined primary keys. Without key the recordset cannot be updated.