Update Access database

[AccessWannaBe]

Can anyone spare a good example of how to update a specific field in a
row within a table in an access database?
I am good with fetching the data and representing in a table, but what
if I want to update a specific field?
Help!

[windandwaves]

Re: Update Access database

AccessWannaBe wrote:[color=blue]
> Can anyone spare a good example of how to update a specific field in a
> row within a table in an access database?
> I am good with fetching the data and representing in a table, but what
> if I want to update a specific field?
> Help![/color]

using PHP? how about a bit of sql, similar to the sql you use to fetch
it...

[Steve]

Re: Update Access database

On Wed, 18 Jan 2006 20:03:37 -0800, AccessWannaBe wrote:
[color=blue]
> Can anyone spare a good example of how to update a specific field in a
> row within a table in an access database?
> I am good with fetching the data and representing in a table, but what
> if I want to update a specific field?
> Help![/color]

Do you mean something along the lines of running the following query in
exactly the same manner as your selection ones...

update <tablename> set <column> = newvalue where <identifier> = <value>

?

If so, I'm not too sure why basic sql queries are being asked in a php
newsgroup.