Changing the cell value in database

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

I want to change the value of the partuicular field in database. How can I do that using some sort of script.
E.g If I have MS Access database (let's say Addresses.mdb) and inside a table with 3 columns and 3 rows. The table name is tblNames.
Eg. 
tblNames

FIELD 1 (Name)

FILED 2 (Name ID)

FILED 3 (Group ID)

Jason

1

4

Jane

2

2

Jill

3

7

I want to change Jane's group ID number from 2 to 5 using asp script.

tblNames 

FIELD 1 (Name)

FILED 2 (Name_ID)

FILED 3 (Group_ID)

Jason

1

4

Jane

2

5

Jill

3

7

How to achieve that.
I want to use some sort of form with, let's say two fields: One filed to type in a Name ID (which is unique), and other input filed to put the new group ID.
Example: 

     Name id: ____________, New Group_id:_________ SUBMIT 

 Note: (lines represent input fields, SUBMIT represents Submit button)

Does anyone know, how to do that? What is the script?
Please, help.

Edited by mantey - 14 November 2005 at 8:06am