[dba-SQLServer] Access 2003 to SQL question (cross posted toaccessd and sqlserver lists)

Has your table a Primary Key? I think a missing PK will make the table
un-updatable through the FE.

Asger

-----Oprindelig meddelelse-----
Fra: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] På vegne af Jeff Barrows
Sendt: 18. august 2009 16:00
Til: accessd; SQLServer
Emne: [dba-SQLServer] Access 2003 to SQL question (cross posted toaccessd
and sqlserver lists)

I have an app that has an Access 2003 front end and an SQL 2005 back end.
Everything has been going fine, but now I noticed that I cannot update one
of my tables through the FE.  I am able to update through the Management
Studio, but need to be able to do it through the FE.  It seems to me that I
had this problem before, but I cannot remember how I fixed it.

Any suggestions?
TIA
-- 
Jeff Barrows
_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com