Welcome to SPN

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

Sign Up Now!
  1.   Become a Supporter    ::   Make a Contribution   
    Target (Recurring Monthly): $200 :: Achieved: $98

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?
    > > > >>
    > > > >>
    > > > >>
    > > >
    > > >
    > > >
     
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page