Inserting a record in an Access database
var thisdatapath = Server.mapPath("SimplyDelicious.mdb");
var dbConn = Server.CreateObject("ADODB.Connection");
dbConn.Open("PROVIDER=MICROSOFT.JET.OLEDB.4.0;DATA SOURCE=" + thisdatapath);
SQL="INSERT INTO pictures (dancerid,pictname,mainpict,twogirlshow) VALUES (";
SQL = SQL + ThisId + ",";
SQL = SQL + "'" + ThisPicName + "',";
SQL = SQL + "'" + "Yes" + "',";
SQL = SQL + "'" + "No" + "')";
var IRS = dbConn.execute(SQL);

