Welcome to SPN

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

Sign Up Now!

I WANT TO UPDATE MY DATABASE BY INSERTING A NEW ROW, HOW DO I DO .

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

  1. row insertion

    row insertion
    Expand Collapse
    Guest

    please help it's very urgent
     
  2. Loading...


  3. Craig Alexander Morrison

    Craig Alexander Morrison
    Expand Collapse
    Guest

    If you mean insert in the same way as Excel...then you cannot.

    What you will need to do is select field or fields and sort the table
    (actually you are better doing this in a query unless the sort field(s) are
    the Primary Key).

    In other words if you want to Insert

    Aerosmith

    between

    Abba
    and
    Zappa

    make that field the field that you sort on.

    --
    Slainte

    Craig Alexander Morrison
    Crawbridge Data (Scotland) Limited
    "row insertion" <row insertion@discussions.microsoft.com> wrote in message
    news:F64A3DE6-19B2-4E19-AD77-F873B786B122@microsoft.com...
    > please help it's very urgent
     
  4. Joseph Meehan

    Joseph Meehan
    Expand Collapse
    Guest

    row insertion wrote:
    > please help it's very urgent


    You add a new record. Since Access Database is a development tool and
    not a ready to use tool, each completed database can be very different. You
    can add new records in a query or a form, or even a table, but it is not
    recommended. You may not may not even see a table or query depending on how
    the developer crafted the database. You may or may not be allowed to add a
    new record depending on how the database was designed.

    I suggest you contact the persons responsible for creating or
    maintaining the database for instructions. Often access is limited
    intentionally.

    --
    Joseph Meehan

    Dia duit
     
  5. Alex Dybenko

    Alex Dybenko
    Expand Collapse
    Guest

  6. John Vinson

    John Vinson
    Expand Collapse
    Guest

    On Tue, 25 Jul 2006 04:30:02 -0700, row insertion <row
    insertion@discussions.microsoft.com> wrote:

    >please help it's very urgent


    I see you're getting some answers, but your question isn't very clear.

    What is the structure of your table?
    What are you trying to accomplish? I'm GUESSING - as some other
    respondents have - that you're thinking of a table as if it were a
    spreadsheet (it's NOT), and that you're trying to insert a record at a
    particular row in the middle of a table.

    Tables don't work that way. A Table is best viewed as an unordered
    "heap" of records. If you want to see records in a particular order
    you must - no option!!! - use a Query sorting the records into that
    order. You can add a new record to the end of the table, and (if
    necessary) requery the Form on which you're displaying the data (using
    a Query on the table), and it will re-sort the records moving the new
    record to its appropriate location.

    If I'm misunderstanding your subject line - please post some useful
    details (rather than just a plea) in the text area.

    John W. Vinson[MVP]
     

Share This Page