Welcome to SPN

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

Sign Up Now!

data not saved

Discussion in 'Information Technology' started by Adrian Porter, Oct 30, 2005.

Tags:
  1. Adrian Porter

    Adrian Porter
    Expand Collapse
    Guest

    I have created a front end in Access 2003 with data on SQL server. When I
    try to create a new record, it won't assign an autonumber (the primary key
    field) and fails to save the data. I am entering data through a form based
    on a straightforward query. What am I doing wrong?
     
  2. Loading...


  3. Douglas J. Steele

    Douglas J. Steele
    Expand Collapse
    Guest

    The Autonumber field isn't included in the query by any chance is it?

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



    "Adrian Porter" <Adrian Porter@discussions.microsoft.com> wrote in message
    news:3FF6A204-12E1-444F-8B53-D140EF751752@microsoft.com...
    >I have created a front end in Access 2003 with data on SQL server. When I
    > try to create a new record, it won't assign an autonumber (the primary key
    > field) and fails to save the data. I am entering data through a form
    > based
    > on a straightforward query. What am I doing wrong?
     
  4. Adrian Porter

    Adrian Porter
    Expand Collapse
    Guest

    Many thanks for responding. Yes it is - is this the problem?

    "Douglas J. Steele" wrote:

    > The Autonumber field isn't included in the query by any chance is it?
    >
    > --
    > Doug Steele, Microsoft Access MVP
    > http://I.Am/DougSteele
    > (no e-mails, please!)
    >
    >
    >
    > "Adrian Porter" <Adrian Porter@discussions.microsoft.com> wrote in message
    > news:3FF6A204-12E1-444F-8B53-D140EF751752@microsoft.com...
    > >I have created a front end in Access 2003 with data on SQL server. When I
    > > try to create a new record, it won't assign an autonumber (the primary key
    > > field) and fails to save the data. I am entering data through a form
    > > based
    > > on a straightforward query. What am I doing wrong?

    >
    >
    >
     
  5. Douglas J. Steele

    Douglas J. Steele
    Expand Collapse
    Guest

    Yes, that's probably the problem. Leave the Autonumber field out, and it
    should get assigned a value.

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



    "Adrian Porter" <AdrianPorter@discussions.microsoft.com> wrote in message
    news:95567108-B21C-4520-931E-AD0BCE5211FD@microsoft.com...
    > Many thanks for responding. Yes it is - is this the problem?
    >
    > "Douglas J. Steele" wrote:
    >
    >> The Autonumber field isn't included in the query by any chance is it?
    >>
    >> --
    >> Doug Steele, Microsoft Access MVP
    >> http://I.Am/DougSteele
    >> (no e-mails, please!)
    >>
    >>
    >>
    >> "Adrian Porter" <Adrian Porter@discussions.microsoft.com> wrote in
    >> message
    >> news:3FF6A204-12E1-444F-8B53-D140EF751752@microsoft.com...
    >> >I have created a front end in Access 2003 with data on SQL server. When
    >> >I
    >> > try to create a new record, it won't assign an autonumber (the primary
    >> > key
    >> > field) and fails to save the data. I am entering data through a form
    >> > based
    >> > on a straightforward query. What am I doing wrong?

    >>
    >>
    >>
     
  6. Adrian Porter

    Adrian Porter
    Expand Collapse
    Guest

    OK - I'll give that a try. Many thanks for your help - I've never used a
    group like this before and am impressed with the speed of the reply to my
    problem!

    "Douglas J. Steele" wrote:

    > Yes, that's probably the problem. Leave the Autonumber field out, and it
    > should get assigned a value.
    >
    > --
    > Doug Steele, Microsoft Access MVP
    > http://I.Am/DougSteele
    > (no e-mails, please!)
    >
    >
    >
    > "Adrian Porter" <AdrianPorter@discussions.microsoft.com> wrote in message
    > news:95567108-B21C-4520-931E-AD0BCE5211FD@microsoft.com...
    > > Many thanks for responding. Yes it is - is this the problem?
    > >
    > > "Douglas J. Steele" wrote:
    > >
    > >> The Autonumber field isn't included in the query by any chance is it?
    > >>
    > >> --
    > >> Doug Steele, Microsoft Access MVP
    > >> http://I.Am/DougSteele
    > >> (no e-mails, please!)
    > >>
    > >>
    > >>
    > >> "Adrian Porter" <Adrian Porter@discussions.microsoft.com> wrote in
    > >> message
    > >> news:3FF6A204-12E1-444F-8B53-D140EF751752@microsoft.com...
    > >> >I have created a front end in Access 2003 with data on SQL server. When
    > >> >I
    > >> > try to create a new record, it won't assign an autonumber (the primary
    > >> > key
    > >> > field) and fails to save the data. I am entering data through a form
    > >> > based
    > >> > on a straightforward query. What am I doing wrong?
    > >>
    > >>
    > >>

    >
    >
    >
     
  7. Adrian Porter

    Adrian Porter
    Expand Collapse
    Guest

    No - I'm afraid removing the primary key field from the query didnt work.

    I have tried writing data directly into the table and it will not save.
    This has not happened before and I am not aware of changing anything.

    I get an error message:

    ODBC call failed ...... String or binary data would be truncated (#8152)
    ..... The statement has been terminated (#3621).

    I have no problem entering data in other tables - either directly or via
    forms based on queries.


    "Adrian Porter" wrote:

    > OK - I'll give that a try. Many thanks for your help - I've never used a
    > group like this before and am impressed with the speed of the reply to my
    > problem!
    >
    > "Douglas J. Steele" wrote:
    >
    > > Yes, that's probably the problem. Leave the Autonumber field out, and it
    > > should get assigned a value.
    > >
    > > --
    > > Doug Steele, Microsoft Access MVP
    > > http://I.Am/DougSteele
    > > (no e-mails, please!)
    > >
    > >
    > >
    > > "Adrian Porter" <AdrianPorter@discussions.microsoft.com> wrote in message
    > > news:95567108-B21C-4520-931E-AD0BCE5211FD@microsoft.com...
    > > > Many thanks for responding. Yes it is - is this the problem?
    > > >
    > > > "Douglas J. Steele" wrote:
    > > >
    > > >> The Autonumber field isn't included in the query by any chance is it?
    > > >>
    > > >> --
    > > >> Doug Steele, Microsoft Access MVP
    > > >> http://I.Am/DougSteele
    > > >> (no e-mails, please!)
    > > >>
    > > >>
    > > >>
    > > >> "Adrian Porter" <Adrian Porter@discussions.microsoft.com> wrote in
    > > >> message
    > > >> news:3FF6A204-12E1-444F-8B53-D140EF751752@microsoft.com...
    > > >> >I have created a front end in Access 2003 with data on SQL server. When
    > > >> >I
    > > >> > try to create a new record, it won't assign an autonumber (the primary
    > > >> > key
    > > >> > field) and fails to save the data. I am entering data through a form
    > > >> > based
    > > >> > on a straightforward query. What am I doing wrong?
    > > >>
    > > >>
    > > >>

    > >
    > >
    > >
     
  8. Douglas J Steele

    Douglas J Steele
    Expand Collapse
    Guest

    Sounds as though the problem might be with that specific table. It might be
    worth asking in a SQL Server group.

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


    "Adrian Porter" <AdrianPorter@discussions.microsoft.com> wrote in message
    news:793BC3B1-1EA7-4C83-88E2-6ACC2A0A1E1A@microsoft.com...
    > No - I'm afraid removing the primary key field from the query didnt work.
    >
    > I have tried writing data directly into the table and it will not save.
    > This has not happened before and I am not aware of changing anything.
    >
    > I get an error message:
    >
    > ODBC call failed ...... String or binary data would be truncated (#8152)
    > .... The statement has been terminated (#3621).
    >
    > I have no problem entering data in other tables - either directly or via
    > forms based on queries.
    >
    >
    > "Adrian Porter" wrote:
    >
    > > OK - I'll give that a try. Many thanks for your help - I've never used

    a
    > > group like this before and am impressed with the speed of the reply to

    my
    > > problem!
    > >
    > > "Douglas J. Steele" wrote:
    > >
    > > > Yes, that's probably the problem. Leave the Autonumber field out, and

    it
    > > > should get assigned a value.
    > > >
    > > > --
    > > > Doug Steele, Microsoft Access MVP
    > > > http://I.Am/DougSteele
    > > > (no e-mails, please!)
    > > >
    > > >
    > > >
    > > > "Adrian Porter" <AdrianPorter@discussions.microsoft.com> wrote in

    message
    > > > news:95567108-B21C-4520-931E-AD0BCE5211FD@microsoft.com...
    > > > > Many thanks for responding. Yes it is - is this the problem?
    > > > >
    > > > > "Douglas J. Steele" wrote:
    > > > >
    > > > >> The Autonumber field isn't included in the query by any chance is

    it?
    > > > >>
    > > > >> --
    > > > >> Doug Steele, Microsoft Access MVP
    > > > >> http://I.Am/DougSteele
    > > > >> (no e-mails, please!)
    > > > >>
    > > > >>
    > > > >>
    > > > >> "Adrian Porter" <Adrian Porter@discussions.microsoft.com> wrote in
    > > > >> message
    > > > >> news:3FF6A204-12E1-444F-8B53-D140EF751752@microsoft.com...
    > > > >> >I have created a front end in Access 2003 with data on SQL server.

    When
    > > > >> >I
    > > > >> > try to create a new record, it won't assign an autonumber (the

    primary
    > > > >> > key
    > > > >> > field) and fails to save the data. I am entering data through a

    form
    > > > >> > based
    > > > >> > on a straightforward query. What am I doing wrong?
    > > > >>
    > > > >>
    > > > >>
    > > >
    > > >
    > > >
     

Share This Page