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.
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):