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

[Guest]

please help it's very urgent

 

[Craig Alexander Morrison]

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.

 

[Alex Dybenko]

Hi,
you can either use Append Query or open recordset and add using AddNew and
update methods. Look for AddNew method in Access help

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com

 

[Joseph Meehan]

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.

 

[John Vinson]

On Tue, 25 Jul 2006 04:30:02 -0700, row insertion <row

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]