Inserting rows into a SQL Server table - problem 1

[VictoriaWass]

I have a database on a SQL server and I am developing an Access 2000 project front end.
I need to create a table which the user can then key information to via a bound access subform, bound to this underlying SQL table.
My problem is that when I try to do this, the table does not allow rows to be added. There is an existing table in the database which does allow this to happen, and I have tried to copy all properties/permissions etc on this table to my new one, but simply cannot get it to allow new rows to be added.
Has anyone got any ideas where else I can look, or what I might have done wrong. Can anybody help?? Please!

Vicky

 

[tlbroadbent]

The SQL table must have a unique index, primary key or timestamp column to be updateable from Access. Is it possible that the table you reference does not meet one of these conditions? Terry L. Broadbent
faq183-874 contains some tips and ideas for posting questions in these forums. Please review it and comment if you have time.
NOTE: Reference to the FAQ is part of my signature and is not directed at any individual.