Can not run SQL update statement

[jsabo]

Hello,

I am very near finishing the script below. toward the bottom in a loop, i have "DoCmd.RunSQL SQL_String" but when it gets to this point, i get an error message stating, "Run-time error '2046': The command or action 'RunSQL' isn't available now."

Any ideas? the only spot i see myself disconnecting from the database is the condition endnow statement, unless im missing something:

Please Login or Register  to view this content.

I have bolded the line where the error occurs.

[jsabo]

Nevermind, got it working. Turns out, i was closing the connection at con.Close.

Then, instead of DoCmd.RunSQL SQL_String , used con.Execute (SQL_String).