Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Add new record disabled

Discussion in 'Information Technology' started by Yo, Jul 28, 2006.

  1. Yo

    Yo
    Expand Collapse
    Guest

    Hi!
    I'm using Access 2003 (WinXP SP2) with ODBC linked tables to SQL Server
    2000. AllowAditionns is set to "Yes" on a form created by wizard with linked
    tables.

    Problem: Add new Record is allways disabled so I cannot add (or edit) data
    through a form as well as directly in data when a linked table is opened in
    datasheet view.

    Thanks in advance.
     
  2. Loading...

    Similar Threads Forum Date
    Sikh News Record single day paddy arrival in Punjab (New Kerala) Breaking News Oct 11, 2007
    Sikh News Paddy production hits a record high in Punjab (New Kerala) Breaking News Sep 28, 2007
    Sikh News Paddy production hits a record high in Punjab (ANI via Yahoo! India News) Breaking News Sep 27, 2007
    I Will Miss You... We Had A Good Go... So Long Gallbladder! Blogs Jan 24, 2016
    Rolling the addiction ball Blogs Oct 17, 2015

  3. Adam Thwaites

    Adam Thwaites
    Expand Collapse
    Guest

    Check you have the right links between your tables, sometimes when you have
    your two linked tables in a query it won't let you add, edit or delete those
    records. You may need to have one of the tables showing in a sub form.
    --
    Adam Thwaites
    Access Database Designer
    adam.thwaites.remove@thisbit.mercedes.co.uk
    Manchester, UK


    "Yo" wrote:

    > Hi!
    > I'm using Access 2003 (WinXP SP2) with ODBC linked tables to SQL Server
    > 2000. AllowAditionns is set to "Yes" on a form created by wizard with linked
    > tables.
    >
    > Problem: Add new Record is allways disabled so I cannot add (or edit) data
    > through a form as well as directly in data when a linked table is opened in
    > datasheet view.
    >
    > Thanks in advance.
     
  4. Douglas J Steele

    Douglas J Steele
    Expand Collapse
    Guest

    Do you have primary keys defined for all of the tables?

    --
    Doug Steele, Microsoft Access MVP
    http://I.Am/DougSteele
    (no e-mails, please!)


    "Yo" <Yo@discussions.microsoft.com> wrote in message
    news:CCC17EFA-8059-40E2-9D31-0597C1D775C2@microsoft.com...
    > Hi!
    > I'm using Access 2003 (WinXP SP2) with ODBC linked tables to SQL Server
    > 2000. AllowAditionns is set to "Yes" on a form created by wizard with

    linked
    > tables.
    >
    > Problem: Add new Record is allways disabled so I cannot add (or edit) data
    > through a form as well as directly in data when a linked table is opened

    in
    > datasheet view.
    >
    > Thanks in advance.
     
  5. Yo

    Yo
    Expand Collapse
    Guest

    One SQL Server table linked to one Access table.
    Simple form created by wizard. No subforms. Form source is specified linked
    table (not query).

    Everythig worked fine until recent. I think some Office patch coused the
    problem.

    "Adam Thwaites" wrote:

    > Check you have the right links between your tables, sometimes when you have
    > your two linked tables in a query it won't let you add, edit or delete those
    > records. You may need to have one of the tables showing in a sub form.
    > --
    > Adam Thwaites
    > Access Database Designer
    > adam.thwaites.remove@thisbit.mercedes.co.uk
    > Manchester, UK
    >
    >
    > "Yo" wrote:
    >
    > > Hi!
    > > I'm using Access 2003 (WinXP SP2) with ODBC linked tables to SQL Server
    > > 2000. AllowAditionns is set to "Yes" on a form created by wizard with linked
    > > tables.
    > >
    > > Problem: Add new Record is allways disabled so I cannot add (or edit) data
    > > through a form as well as directly in data when a linked table is opened in
    > > datasheet view.
    > >
    > > Thanks in advance.
     
  6. Yo

    Yo
    Expand Collapse
    Guest

    One table, and yes, it does have primary key.

    "Douglas J Steele" wrote:

    > Do you have primary keys defined for all of the tables?
    >
    > --
    > Doug Steele, Microsoft Access MVP
    > http://I.Am/DougSteele
    > (no e-mails, please!)
    >
    >
    > "Yo" <Yo@discussions.microsoft.com> wrote in message
    > news:CCC17EFA-8059-40E2-9D31-0597C1D775C2@microsoft.com...
    > > Hi!
    > > I'm using Access 2003 (WinXP SP2) with ODBC linked tables to SQL Server
    > > 2000. AllowAditionns is set to "Yes" on a form created by wizard with

    > linked
    > > tables.
    > >
    > > Problem: Add new Record is allways disabled so I cannot add (or edit) data
    > > through a form as well as directly in data when a linked table is opened

    > in
    > > datasheet view.
    > >
    > > Thanks in advance.

    >
    >
    >
     

Share This Page