Database

<br />
sSQL =	"SELECT Table1.*, Table2.* " &_<br />
	"FROM Table1 LEFT JOIN Table2 ON Table1.Name = Table2.Name"<br />
rec.CursorLocation = adUseClient<br />
rec.CacheSize = 25<br />
rec.PageSize = 25<br />
rec.Open sSQL, con, adOpenForwardOnly, adLockReadOnly<br />

tblJobs ( ID, ... )
tblAreas ( ID, ... )
tblSchedule ( ID, JobID, AreaID, ... )
tblJobAreaLink ( JobID, AreaID )

con.Execute "DELETE * FROM tblJobs WHERE ID=" & id
con.Execute "DELETE * FROM tblSchedule WHERE JobID=" & id

      OleDbConnection thisConnection=new OleDbConnection(
    @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\Inetpub\wwwroot\First\Testing.mdb");

thisConnection.Open();
// create DataAdapter object for update and other operations
    OleDbDataAdapter thisAdapter = new OleDbDataAdapter(
        "SELECT * FROM Table1", thisConnection);
// create CommandBuilder object to build SQL commands
OleDbCommandBuilder thisBuilder = new OleDbCommandBuilder(thisAdapter);
// create DataSet to contain related data tables, rows, and columns
DataSet thisDataSet = new DataSet();
// fill DataSet using query defined previously for DataAdapter
thisAdapter.Fill(thisDataSet, "Table1");
DataRow myRow=thisDataSet.Tables["Table1"].NewRow();
myRow["Column1"]="mazy";
myRow["Column2"]="Hello everybody!";
myRow["Column3"]=312;
thisDataSet.Tables["Table1"].Rows.Add(myRow);

thisAdapter.Update(thisDataSet,"Table1");

thisConnection.Close();