Can't edit data in a table in ADP

[amarkmac]

I've created an ADP project containingnumerous tables. One (and only one!) table in the set will not open in edit mode while in Access. Here are the particulars:

1) The table was created from scratch in SQL Enterprise Manager,
2) The table is editable in SQL Enterprise Manager,
3) The table permissions appear to be set correctly (and are the same as all the other tables which all allow editting in Access)
4) I open the Access project and double-click the table. The "add record" navigation button is disabled, and any attempt to edit a field elicits a "This recordset is not updatalbe" error.
5) However, I can open the table in Design mode in Access, make changes, and save them.

Any ideas? This is very frustrating!

Mark

 

[amarkmac]

Never mind...... The table in question did not have a primary key specified, and without it the ADP/SQL server apparently can't figure out how to lock the records for write access.

Thanks anyway.
Mark