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

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
>
>


-- 
Jeff Barrows