I think this should work... right?
I haven't tried it but I don't know why this wouldn't work when loaded.
Code:
Dim cnn
Dim rst
Dim ConnectString
Set cnn = Server.CreateObject("ADODB.Connection")
Set rst = Server.CreateObject("ADODB.Recordset")
ConnectString = "Provider = Microsoft.Jet.OLEDB.4.0; Data Source = c:\inetpub\wwwroot\db\whatever.mdb"
cnn.Open ConnectString
rst.Open "SELECT * FROM table WHERE status = 'FALSE'"
rst.Update
rst("status") = "True"
rst.Update
rst.Close
cnn.Close
Set rst = Nothing
Set cnn = Nothing
This code should open the database, grab the first record with the status of 'False' and change it to 'True'.