jwcolby
jwcolby at colbyconsulting.com
Tue Aug 18 11:30:42 CDT 2009
I ran into that myself the other day. Bit fields with null values = no update in SQL Server. John W. Colby www.ColbyConsulting.com Jeff Barrows wrote: > I found the solution! > > First of all, yes I did have a PK in the table. What I forgot was, the > other guy working on this app added two bit fields and left them with null > values. As soon as I made them all = 0, everything works fine. > > Thanks for the help! > > On Tue, Aug 18, 2009 at 10:46 AM, Francisco Tapia <fhtapia at gmail.com> wrote: > >> 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 >>> >>> >> _______________________________________________ >> dba-SQLServer mailing list >> dba-SQLServer at databaseadvisors.com >> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver >> http://www.databaseadvisors.com >> >> > >