Chapter 16 Accessing Database

Bruce A Smith · June 16th, 2009, 02:48 PM

Pages: 546 -- 548
I have been trying to connect to my database (MDB Access 2003).

With the execption of it being the NWind database I do all of the steps 1 ... 7 without problems.

In step 7, I test the connection and the dialog box replys in the affirmative.

I do all the "check it out" or test buttons on the IDE wizard.

I saw all my tables in the MDB.

I saw all the rows in the table which I selected, with the propert data bases.

When I select RUN from the debug tool bar the form renders, and the data grid is empty.

The grid responds to adding new data just like a Data Set in Access Proper. But nothing
is added.

In step 12, there is no population of the Data Grid Control. I am at the end of my patience.
I have used ODBC via C and C++ to connect with Access back in the 1990s and Oracal also.

Using the wizards there must be some outrageous oversite on my part, it just doesn't work. The MDB has only one Account 'Admin' with no password. The grid shows the column names but no data.

What have I stepped on??? All my upgrades are current as of (05.17.200)

Reguards Bruce

Thearon · June 23rd, 2009, 06:41 AM

Bruce,

Can you post your code for this? I suspect you may just need to call the Bind method on the grid after you have bound it to the dataset.

Thearon

Bruce A Smith · June 30th, 2009, 12:49 PM

Thanks for just getting back to me!!

I am feeling like the ambassador to the Planet Stupid!

I zipped up the source project @ 1.22 mb

Couldn't find an attachment button on the reply to thread.

The VB code is 80kb in size!

That seems like a very big thread, since, this is my first experience with any kind of fourm group, I am sorta at a loss for the do's and don'ts and the other niceties.

Do you want an 80k thread??

regards Bruce

bnews987 · July 1st, 2009, 12:37 PM

Bruce, Can you use Access to update your data? Bryan

Bruce A Smith · July 7th, 2009, 01:46 PM

The NW Database was time stampled 1998, I have a 2003 Version MDB and a 2007 accdb file that I have tried this with. Thru access 2007 I have opened and connected to various MDBs, on several occasions converting data from 2003 to 2007.
In VB 2008 while testing the example I saw good data from the wizards "test" buttons. When running the debugger, I can see the column heads with the column names, The navigation transport buttons are greyed out, and the data edit control has no data. It does not seem to be a connection problem as much as what is supposed to happen afterwards.

Again thanks for the response

Regards Bruce

bnews987 · July 7th, 2009, 10:29 PM

Do you have this code in form1.vb. It wraps poorly, but this should be in the form load event. There is 1 line of code Me.CustomerQueryTableAdapter.Fill(Me.NorthwindData Set.CustomerQuery)

Code:

 
Public Class Form1
    Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
        Me.CustomerQueryTableAdapter.Fill(Me.NorthwindDataSet.CustomerQuery)
    End Sub
End Class

Bryan

Bruce A Smith · July 8th, 2009, 08:31 AM

Thanks,

I regenerated the project. The version of NW had no customer query, so I selected the categories table.

The code emitted from the wizzards was as you stated, with the exception of NW CategoryTable string insead of the Customer Query. With the properties set to false on ADD and DELETE, couldn't find EDIT. Ran with the debugger and got the column headings. Went back to the properties set ADD and DELETE to true. Re-ran. The control would accept data entry, but it wasn't saved in the MDB. Still not happening.

I know that communicating through the fourm protects you guys from the masses. Could you create a temporary mail box so that I may zip up my project and one time email it to you. You have my direct email URL.

regards Bruce

bnews987 · July 12th, 2009, 01:19 PM

I sent you an email. Bryan