Simple Access Question II

I have a table with 1024 records.

Register Value
----------------
1 13
2 1254
3 4543
4 135
etc.--> 1024
----------------

How the hell do I write a value to "Value" in a specific record when I know what record (e.g 1000) I want to write to?

The only thing I've come up with, is MoveNext until I reach the desired record, but that's so slow!

Please help me, gurus and semi-gurus!

D

Use some SQL then create a recordset as follows

Code:

---

dim rs as New ADODB.Recordset

sSQL = "SELECT * FROM [Your Table] WHERE [Your Field]=100;"

rs.Open sSQL

---

Hope this is of use

Hmmm...

VB says:
-----------------------------
User-defined type not defined
-----------------------------

Dunnowattado!

Thanks anyway, but could you explain it a little bit more in detail, please?

D

Sorry Dragev
This should explain it better.

Make sure in your references you have the Microsoft AtiveX Data Objects Library 2.1 checked as well.

Code:

---

        Dim cnn As ADODB.Connection
        Dim rs As ADODB.Recordset
        Dim sSQL As String
       
        'Open the connection to your database
        Set cnn = New ADODB.Connection
            With cnn
                .Provider = "Microsoft.Jet.OLEDB.4.0"
                .Open "C:\MyDB.mdb"
            End With

    'Enter your table name and field name where appropriate, also remeber to enclose the
    'value in "" if it is a string value
    'i.e. sSQL = "SELECT * FROM tblMain WHERE ID =1000;"
    sSQL = "SELECT * FROM [Your Table] WHERE [Your Field] =[Your value];"

    'Open the recordset based on the SQL string
    Set rs = New ADODB.Recordset
        With rs
            .CursorType = adOpenKeyset
            .LockType = adLockOptimistic
            .Open sSQL, cnn
        End With

---

Thanks, man!
Great!

D