I have created a MS Access database on a remote development server. I wish to take data from an online form and add it to a table (INPUT) in my remote database (Project_01.mdb). The vbScript code that I am using is:
sql_insert = "INSERT INTO INPUT (Manager, Email, Number, Division, Description) VALUES ('" & _
proName & "', '" & proEmail & "', '" & proNumber & "', '" & proDivision & "', '" & proDescription & "');"
conString = "Provider=SQLOLEDB;Data Source=.;Initial Catalog=Project_01.mdb;Integrated Security=SSPI;"
Set con=createobject("adodb.connection")
If (err.number <> 0) Then
Alert "Connection to the Proposal Database was not successful!"
Else
Alert "Connection to the Proposal Database was successful!"
& ...
Go to the complete details ...