I volunteer for a local animal rescue group and have been tasked to maintain the group's website since the webmaster moved on. I have little experience with code, so I am looking for a little assistance. Kinda learning on the fly, so to speak.
I am attempting to gather data from a web page and send to an access database and have hit a snag.... the web page is at https://triangleshelties.com/content...ntake_form.asp and each section has a different table in the access database. When the code moves from inserting data into the database from the first section (Owner information) to the second section (Information about your dog) I get the title error. I have checked the spelling for each field in the code and database, and so forth and cannot find an error, so I am assuming my method of moving from one table to another is the problem. Can anyone lend some assistance or suggestions?
2) Remove the link to your website from your post. You're wide open to SQL injection - someone could extract all the info in your database or delete it all. You can fix that with parameters:
I've done the first query as an example (untested). Replace lines 507-530 with this:
dim cmd : set cmd = server.createobject("adodb.command")
set cmd.ActiveConnection = objConn