Record Not updatable question

[Guest]

Hi, I have created an Access project (adp) to view/update different tables of
a SQL Server 2000 database. The database connection is set to use the owner
credentials of the SQL database. However, when trying to insert a new record
in a table, I am getting a "record not updatable" message. What is weird is
that I am able to insert records in some tables, while the operation is
forbidden for other tables. Is there any property that prevents me to update
some of my tables ?
Any help welcome !
Joe

 

[John Vinson]

Is there any property that prevents me to update
some of my tables ?

The lack of a primary key is the first thing that comes to mind.

John W. Vinson[MVP]