T
tdb
Guest
This is my first post so I hope I'm in the right place.
I am receiving an Invalid Argument error on a rst.Update Instruction. The help refers to a argument in a DLL but does not specify what DLL it is. I uninstalled/reinstalled Access but no good.
Sample (paraphrased) Code:
Public Sub update
Dim db As Database
Dim rst As RecordSet
Set db=Currentdb
Set rst = db.OpenRecordSet("qry-date")
rst.MoveLast
rst.MoveFirst
Do Until rst.EOF
(instruction)
rst.Edit
(instruction to update rst --rst!field = ws)
rst.Update
rst.MoveNext
Loop
rst.Close
End Sub
I am updating a field in the recordset based upon other fields in same recordset. The table contains approx. 500,000 rows. When this happens it corrupts the db and I either have to repair or copy to a new db. If more information is required I'll try to supply it.
Any help would be appreciated.
Thanks
T Booth
I am receiving an Invalid Argument error on a rst.Update Instruction. The help refers to a argument in a DLL but does not specify what DLL it is. I uninstalled/reinstalled Access but no good.
Sample (paraphrased) Code:
Public Sub update
Dim db As Database
Dim rst As RecordSet
Set db=Currentdb
Set rst = db.OpenRecordSet("qry-date")
rst.MoveLast
rst.MoveFirst
Do Until rst.EOF
(instruction)
rst.Edit
(instruction to update rst --rst!field = ws)
rst.Update
rst.MoveNext
Loop
rst.Close
End Sub
I am updating a field in the recordset based upon other fields in same recordset. The table contains approx. 500,000 rows. When this happens it corrupts the db and I either have to repair or copy to a new db. If more information is required I'll try to supply it.
Any help would be appreciated.
Thanks
T Booth