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

#1 (**permalink**) 28-Jul-2006, 08:41 AM

please help it's very urgent
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/13868-i-want-update-my-database-inserting.html

*

#2 (**permalink**) 28-Jul-2006, 08:41 AM

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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13868
(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.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13868

--
Slainte

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

#3 (**permalink**) 28-Jul-2006, 08:41 AM

row insertion wrote:
> please help it's very urgent
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13868

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.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13868

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

--
Joseph Meehan

Dia duit

#4 (**permalink**) 28-Jul-2006, 08:41 AM

Hi,
you can either use Append Query or open recordset and add using AddNew and
update methods. Look for AddNew method in Access help
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13868

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

"row insertion" insertion@discussions.microsoft.com> wrote in message
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13868
news:F64A3DE6-19B2-4E19-AD77-F873B786B122@microsoft.com...
> please help it's very urgent

#5 (**permalink**) 28-Jul-2006, 08:41 AM

On Tue, 25 Jul 2006 04:30:02 -0700, row insertion 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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13868
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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13868
details (rather than just a plea) in the text area.

John W. Vinson[MVP]