updating a dbase file

[49er]

Can someone give me some insight as to how to edit and then update a dbase file?
The error "Operation is not supported for this type of object" is generated when I try to execute the update statement in the following code:

Code:
strFileName = InputBox("Enter path to streets.dbf", _
"Create Street Label Fields For Internet Apps", "x:\wrkarea\gis\brett&quot
Set dbCurrent = OpenDatabase(strFileName, False, False, "dbase IV;&quot
Set rs = dbCurrent.OpenRecordset("streets&quot
Do Until rs.EOF
rs.Edit
rs.Fields("myabbtype&quot.Value = rs.Fields("st_type&quot.Value
rs.Update
rs.MoveNext
Loop
dbCurrent.Close

 

[shepherd]

Check out the last example on this page:

http://msdn.microsoft.com/library/d.../en-us/office97/xhtml/output/F1/D2/S5A30A.asp