I've read quite a number of posts in regard to writing back to the database and had it working when I hard-coded the values but when I changed to use variables, it does not work. When I try to run the code below using the variables, I get a "No update permissions!" error (exactly as the code says - just not sure what, exactly, I am doing wrong.
Details:
Desktop client only (no web deployment planned), write back to database (initially insert, but later edit & delete options as well).
The Macro is as follows (the real code has an actual server listed in the Data Source= portion, left it out here):
sub DataInsert
set conn=CreateObject("ADODB.Connection")
conn.Open "Provider='sqloledb';Data Source=<MyServer>;Initial Catalog='Rally';Integrated Security='SSPI';"
set rs=CreateObject("ADODB.recordset")
' Database Update
sql="INSERT INTO mw_TestTable VALUES ('" & vTestChar & "', " & vTestInt & ", '" & vTestDate & "')"
on error resume next
conn.Execute sql
if err <> 0 then
msgbox("No update permissions! " & err )
end if
conn.close
end sub
Thanks for any help you can provide.
Mark.
