Welcome to SPN

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

Sign Up Now!

My Access database is mixing up the record numbers in the table

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

  1. achristian

    achristian
    Expand Collapse
    Guest

    My Database is mixing up the record in the table and the form. It says its a
    1017 system error. How do I get the records back into their correct order?
     
  2. Loading...


  3. Douglas J Steele

    Douglas J Steele
    Expand Collapse
    Guest

    What exactly are the symptoms?

    You do realize, I hope, that you cannot make any assumptions about the order
    of records in tables.

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


    "achristian" <achristian@discussions.microsoft.com> wrote in message
    news:AD29AC74-2515-46E1-80D7-0858069643DB@microsoft.com...
    > My Database is mixing up the record in the table and the form. It says

    its a
    > 1017 system error. How do I get the records back into their correct

    order?
     
  4. KARL DEWEY

    KARL DEWEY
    Expand Collapse
    Guest

    Records are not stored in any order. You can display them in an order by
    indexing or setting sort in a query, form or report.

    "achristian" wrote:

    > My Database is mixing up the record in the table and the form. It says its a
    > 1017 system error. How do I get the records back into their correct order?
     
  5. Joseph Meehan

    Joseph Meehan
    Expand Collapse
    Guest

    achristian wrote:
    > My Database is mixing up the record in the table and the form. It
    > says its a 1017 system error. How do I get the records back into
    > their correct order?


    What record numbers? Access does not have record numbers.

    Records in a table are not in a specific order. If you want records in
    an order, you need to provide for that. Considering a table as a bucket of
    data is the best way of handling it.

    Autonumber is not intended as a way of providing a record order, only a
    way of providing a unique number for each record.

    How does the error message fit into the problem?

    --
    Joseph Meehan

    Dia duit
     
  6. '69 Camaro

    '69 Camaro
    Expand Collapse
    Guest

    Hi.

    > It says its a
    > 1017 system error.


    Do you mean system error -1017? If so, what's the exact error message? The
    error number means different things, depending upon the context, such as a
    replicated database's synch error, a compaction error, or a conversion
    error.

    HTH.
    Gunny

    See http://www.QBuilt.com for all your database needs.
    See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
    http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
    info.


    "achristian" <achristian@discussions.microsoft.com> wrote in message
    news:AD29AC74-2515-46E1-80D7-0858069643DB@microsoft.com...
    > My Database is mixing up the record in the table and the form. It says
    > its a
    > 1017 system error. How do I get the records back into their correct
    > order?
     

Share This Page