Posted on: 2/18/2014 3:18:03 PM | Views : 755

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