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

Agreed, unless you are updating your tables through sprocs, any bound tables
to the FE gui will not be updateable until you have a PK with
auto-incrementing id.
-Francisco
http://sqlthis.blogspot.com | Tsql and More...


On Tue, Aug 18, 2009 at 7:54 AM, Asger Blond <ab-mi at post3.tele.dk> wrote:

> 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
>
>
>
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
>
>