SQL database data is readonly and will not change 1

[diamondsc]

We have just received Microsoft SQL Server 2000 and installed it on an eval copy of Windows Server 2003. I used the import wizard to import data from an Access 2000 database. This seemed to work well. I linked our Access 2000 front end application to the data tables and that seemed to work well. However, I cannot add or edit data from the Access front end. I can add and edit data from within the Enterprise Manager in SQL Server. What am I doing wrong?

Also, I'm experienced in Access and a novice at SQL Server. Is there a good training course available online or in a classroom that someone could recommend? Thanks.

 

[SQLSister]

Your problem is that you don't have a unique field. You cannot add or edit records in Access to a SQL Server database without a primary key or unique constrainst or GUID field or identity field that allows SQL to uniquely identify the record.

 

[diamondsc]

Thanks SQLSister, that did the trick.