Database

Private Sub btnopendb_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnopendb.Click<br />
<br />
        Try<br />
<br />
            With OpenFileDialog1<br />
<br />
                ' Check to ensure that the selected file exists.  Dialog box displays a warning otherwise.<br />
<br />
                .CheckFileExists = True<br />
<br />
                ' Check to ensure that the selected path exists.  Dialog box displays a warning otherwise.<br />
<br />
                .CheckPathExists = True<br />
<br />
                ' Get or set default extension. Doesn't include the leading ".".<br />
<br />
                .DefaultExt = "MDB"<br />
<br />
                ' Return the file referenced by a link? If False, simply returns the selected link file.<br />
                ' If True, returns the file linked to the LNK file.<br />
<br />
                .DereferenceLinks = True<br />
<br />
                .InitialDirectory = "C:\"<br />
<br />
                .Filter = "mdb|*.mdb"<br />
<br />
                .Multiselect = False<br />
<br />
                .RestoreDirectory = True<br />
<br />
                '.FilterIndex = 1<br />
<br />
            End With<br />
<br />
            If OpenFileDialog1.ShowDialog() = Windows.Forms.DialogResult.OK Then<br />
<br />
                txtopendb.Text = OpenFileDialog1.FileName<br />
<br />
            End If<br />
<br />
        Catch exp As Exception<br />
            MessageBox.Show(exp.Message, Me.Text)<br />
        End Try<br />
<br />
<br />
    End Sub<br />

CREATE TABLE AddrBook
  (FILE_NAME C (50) NOT NULL
 )

The snippet of code I am using to do this is:
   /* Establish Connection to Data Source - DO NOT DELETE */
   try {
       nRC = DBSQL.Open(chdatabaseName,FALSE,FALSE,_T("ODBC;"));
   }
	catch (CDBException* e) {
		cout<<"ERROR: "<<e->m_strError<<endl;
		cout<<"Return Code is: "<<e->m_nRetCode<<endl;
		return(nRC);
	}
	while (FileSQL.BuildSQLStmt()) {
	     try {
		DBSQL.ExecuteSQL(FileSQL.SQLStmt.textP);
	     }
	     catch (CDBException* e) {
		cout<<"ERROR: "<<e->m_strError<<endl;
		cout<<"Return Code is: "<<e->m_nRetCode<<endl;
		return(nRC);
	     }