Updating data into ADO Fields
I've always had much better success with using INSERT SQL statements rather
than using the Update method.
Set rcTemp = New ADODB.Connection
' setup rcTemp
rcTemp.Execute "INSERT INTO myTable (Field1, Field2...) VALUES (Value1,
'Value2'...)"
ADO and RDO are usually much more forthcoming with descriptive errors when
using this method.
--
John Tabor
http://members.bellatlantic.net/~jftabor
___________
Quote:
>This was working fine. Then one day i opened up the project, and didnt even
>make any changes yet, just tried running the program, and now it doesnt
>work. It updates most of the fields, with one or two exceptions. When it
>gets to those fields, i get the wonderful ADO error <Errors Occured> .
Does
>anyone have any experience with this error, why it might be happening? The
>fields are nothing special, not indexed, not keys, nothing like that.
