Member Avatar for regalla

i want to update the n th row of the ms access table through vb . i request any body to explain the procedure of code giving one example for which i will be thank ful

  • 2 Contributors
  • 1 Reply
  • 86 Views
  • 6 Hours Discussion Span
  • Latest Post Latest Post by selvaganapathy
Member Avatar for selvaganapathy

Hi
> First Connect Vb to your Database
> U Must have primary key in that table to uniquely Choose the nth row.
> Use the primary key to select the row

For Example in ADO
Assume the DataBase is in C:\abc.mdb

''''' ADO Code to Open the Database
Connection

Dim DB as New ADODB.Connection
Dim RS as New ADODB.RecordSet

DB.Open "Provider=Microsoft.JET.OLEDB.4.0;Data Source=C:\abc.mdb"
   DB.CursorLocation = adUseClient 
RS.Open "SELECT * FROM Table WHERE PrimaryKey=n",DB, adOpenDynamic, adLockOptimistic

Now Change thru RS object

Rs.Fields("FieldName") = Value

Note:
Table, PrimaryKey, n, FieldName, Value are used for example, replace appropriate words

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.