
Update method not working
Hi. I have some code that just 'hangs' when the update statement is
getting executed. In the code, several access tables are created, then
linked to an Oracle database via a connect statement. The linking goes
along fine. I am adding a new rec. using the .addnew method. However,
when I get to the .Update line, it just hangs and I have to get out of VB.
I am updating a created recordset that uses nested SQL. I have no problems
until this point. Any ideas?