Thyron:

I'm working with an ACCESS database I originally built with Access 97 and programmed with Visual Basic 4 designed to keep track of the amateur radio contacts I made over the last nineteen years. The database contains nearly 3200 entries. Last year I changed the format to ACCESS 2007 and now want to code it with VB 2005. I'm having trouble devleoping datasets and need help. I prefer to hand code the routines and have used Chapters 5 and 6 of "Beginning Visual Basic 2005 Databases" to develop the sub routine. The routine I use is:
 Private Sub frmContactsShow_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load

        'Establish a connection string
        Dim strConnectionString As String = _
        "Provider =Microsoft.Jet.OLEDB.4.0;" & _
        "Data Source=..:\ktplog.mdb;"
        Dim objConnection As New OleDbConnection(strConnectionString)
        ' Get the Query statement
        storedSQL = lblHidden.Text
        'Declare and initialize a new instance of the OleDbCommand class
        Dim objCommand As New OleDbCommand(storedSQL, objConnection)
        'Declare an OleDbDataAdapter obDject
        Dim objDataAdapter As New OleDbDataAdapter(objCommand)
        'Declare a Datatable object
        Dim objDataTable As New DataTable

        'Set the SelectCommand for the OleDbDataAdapter
        objDataAdapter.SelectCommand = objCommand

        'Populate the DataTable
        objDataAdapter.Fill(objDataTable)

        'Bind the DataTable to the DataGridView
        grdSelectedContacts.DataSource = objDataTable

        'Set the SelectionMode property
        grdSelectedContacts.SelectionMode = DataGridViewSelectionMode.FullRowSelect

        'Catch OleDbException As OleDbException
        'MessageBox.Show(OleDbException.Message, "N7KTP Contact Log Error")


The objCommand "StoredSQL" is a query passed from the previous screen using the lblHidden.Text property to perform the pass.
The query reads 'StoredSQL = "SELECT * FROM ContLog WHERE ContLog.Station LIKE '%" & Me.txtCallSignIn.Text & "%';"

My problem is that I get an OleDbException "Not a Valid File name"
when the progam reaches the line "objDataAdapter.Fill(objDataTable)" is executed. can you review my programming and tell me what I need to do to correct the problem?

Your book has helped me to grasp the new techniques of visual basic but I wish you wrote more examples of hand coating to help me do more hand coating which I feel more comfortable with.

Tnx...

Greenbriar

Greenbriar,

From your error message it sounds like perhaps your connection string is not correct. In fact this code does not look correct: Data Source=..:\ktplog.mdb;. Get rid of the semicolon in this code. Next, ensure your database is one folder above your executable file as indicated in your data source or move the database into the bin folder with your executable and just specify the database name.

Thearon